Adding and removing disk space for SQL2000

15 pts.
Tags:
SQL Server 2000
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!

Answer Wiki

Thanks. We'll let you know when a new response is added.

To do this you’ll need to create a new LUN on the SAN and present it to SQL_SVR_A. Then stop the SQL Server, move the database files to the new smaller drive, keeping all the folder paths the same. Switch the drive letters on the two volumes. Then start the SQL Server Service again. All your databases will now be available.

You can now reclaim the empty volume back on the SAN, delete the LUN, and extend the existing LUN on SQL_SVR_B onto the new empty space.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jclarcher
    Thank you very much for the reply, I appreciate you taking the time to answer! However, if you would please explain a little deeper? When you say move the databases to the new drive, keeping the paths the same: - should the drive letters and paths already be defined on this smaller drive/LUN, or do you mean that the same paths should be defined on different drive letters (there are 11 f: through p:), aka f: = q, g:=r, etc...then once the files are copied, and the original LUN is disabled/removed, rename the drive letters to the original? Thank you, again..
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following