Can a database be moved to a new drive without needing to rebuild the mirror?
I have a 2005 database in the standard edition of SQL Server that is mirrored to a disaster recovery site. I plan to move one of it's data files to a new drive this weekend. Can I pause the mirroring, detach the primary database, move it's data file, reattach it, and resume it's mirror? Or will I need to rebuild the mirror once the move is complete?