I just started with this company and one of the servers I am responsible for uses SQL server. Well the databases are mirrored, but they mirrored it on the same disk array and I want to remove it. What would be the best way to go about doing that. I tried to disable the mirror but after the next reboot SQL Server wouldn't come back up. Any input would be greatly appreciated!

Rocco

-- Anonymous, June 06, 2000

Answers

Rocco,

I would use Transact SQL to do this (and not trust Enterprise Manager). Use ISQL/w and DISK MIRROR and DISK UNMIRROR.

Good Luck,

Eric

-- Anonymous, June 06, 2000