TheHayabusa99men
Newbie
Points: 1
More actions
October 30, 2007 at 7:24 am
#179671
Gents can you tell me how to do this?
HOW TO: Detach an Mirrored SQL 2005 database from C: to the D: drive
Thanks in advanced.
Pim
Steve Jones - SSC Editor
SSC Guru
Points: 734562
October 30, 2007 at 12:05 pm
#746803
I'd think you would just pause mirroring (http://msdn2.microsoft.com/en-us/library/ms175082.aspx), then detach and attach and restart mirroring.
Vidhya Sagar
SSCrazy Eights
Points: 8216
October 31, 2007 at 12:33 pm
#747212
You can try out the suggestion given by Steve.
After attaching in mirror take a tlog backup of the database from principal server and restore with standby option in the mirrored server and then start mirroring.
Regards..Vidhya SagarSQL-Articles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply