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.