Newbie - Detach / Attach in SQL 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Newbie - Detach / Attach in SQL 2005

12 posts, Page 2 of 2

««1 2

Newbie - Detach / Attach in SQL 2005

Rate Topic

Display Mode

Topic Options

Author

Message

William Vach

Posted Tuesday, March 02, 2010 8:52 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:19 AM
Points: 2,107, Visits: 1,066

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

chrisph

Posted Tuesday, March 02, 2010 9:01 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:48 PM
Points: 96, Visits: 397

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 »

12 posts, Page 2 of 2

««1 2

Permissions