A mirrored disk drive containing one of our largest databases on a SQL Server 6.5 platform needs to be swapped out for a larger drive. The log file is on a separate physical device. I am looking for suggestions on the best way to approach this, especially from those who have encountered this situation. My first thought is to: dump db to tape, remove the database device from within Enterprise Manager, shut down SQL Server, remove the mirror on the device (NT level), replace the drives, mirror them (NT), restart SQL Server and add the database device back in, recreate the database for load, and load and restore it from tape.

Any thoughts would be appreciated. Thanks.