Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:32 PM
Points: 2,437, Visits: 1,309
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 99, Visits: 448
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