The scenario:SQL_SVR_A (2000)has x amount 'too much' SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn't have enough space.
What is the best method to 1)remove the disk space and keep all db's in-tact (backup/recovery?, or another way??) and 2)how to add the new space to the server B, keeping the db's in-tact (or possibly re-aligning them to alternate locations on the new space)?
Thank you for any input!
February 11, 2010 4:35 PM
February 11, 2010 9:02 PM