Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Newbie - Detach / Attach in SQL 2005 Expand / Collapse
Posted Tuesday, March 2, 2010 8:52 AM


Group: General Forum Members
Last Login: Tuesday, May 24, 2016 8:10 AM
Points: 2,975, Visits: 1,625
If you use this method, make sure that users are not entering or modifying data because you will have issues with transactions made to the old database after the backup was completed, but before the new database was restored.
Post #875231
Posted Tuesday, March 2, 2010 9:01 AM


Group: General Forum Members
Last Login: 2 days ago @ 1:30 PM
Points: 135, Visits: 607
As an update we went ahead with the detach/attach, as this is what the DB programmer suggested in the end for convenience.
I am still puzzled as to why people are against this method, well I suppose if the DB is in production it causes more room for error than a backup/restore. Since this DB is fairly new and not utilized this didn't pose a problem.

Thanks everyone for your help!
Post #875244
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse