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
Author
Message
Posted Tuesday, March 2, 2010 8:52 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 3,076, Visits: 1,678
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 30, 2016 3:35 PM
Points: 135, Visits: 622
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