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 «««12345

Moving Database Files in SQL Server Expand / Collapse
Author
Message
Posted Friday, May 17, 2013 11:23 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 318, Visits: 522
Perry Whittle (5/17/2013)
kevaburg (5/17/2013)
Of course, in order to do this you Need to be using the Enterprise Version of the Software.....

On a slightly different plain to my article as this is moving a database across instances. The synchronous mirroring in standard edition will achieve the same results.


I was actually referring to use the Backup/Restore method over the Attach/Detach method. As has been pointed out to me, simply using the latter method can result in an inconsistent database because the Transaction log is missing. This means that when the instance/database starts up and recovery is performed, uncommitted Transactions cannot be rolled back. This is where the database becomes inconsistent and Problems start to occur.

If the attach/detach method really must be used, then it should be as a last Resort or when the admin knows 100% that consistency can be guaranteed.
Post #1454232
Posted Friday, May 17, 2013 11:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 318, Visits: 522
Guess who didn't read the article BEFORE posting comments....?

Sorry Perry....
Post #1454233
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse