What about some tran restores?

> To: [Email address protected] From: mssqldba-ezmlmshield-x22244433.[Email address protected] Date: Fri, 29 Jun 2007 13:00:25 -0400> Subject: Live DEV Site via log shipping, replication, mirroringHi guys> > I am looking into taking some of our live production databases from our> datacenters and bringing them local, so I can use them as a dev db.> > Now all the tools tht I have seen whether it be log shipping or> replication, restore the dbs in stand by mode. Which is more for a> disaster recovery model.> > I am not looking to do DR, I want the dbs to be accessible to our> developers to make changes. And I think that's where the problem comes> in. If you use log shipping then once the db gets changed, it will be> out of sync with the prod db, and therefore a new production db will> need to be restored prior to restoring another log.> > > > I am not looking for up to the minute data for our developers, I would> be able to probably take semi daily, one in the afternoon and one at> night> > > > Does anyone know of any third party tools that would allow me to get> this done, or know of a way I could somehow use replication or log> shipping? Or any other native sql method?> > > > > > ---------------------------------------------------------------------> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY> To post a dba job: http://jobs.lazydba.com> To subscribe : http://www.LazyDBA.com> To unsubscribe: http://www.lazydba.com/unsubscribe.html>
MS Sql Server LazyDBA home page