Removing and adding new space to databases

SQL Server Ask the Experts

2585 pts.

Tags:

SAN

SQL Server

SQL Server database

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, first, remove the disk space and keep all DBs in-tact and secondly, how to add new space to ServerB, keeping the DBs in-tact, or possibly re-aligning them to alternate locations in the new space?

Asked: February 24, 2010 7:38 PM Last updated: December 12, 2014 6:35 PM

Answer Wiki

Last updated: December 12, 2014 6:35 PM GMT

Michael Tidmarsh62,220 pts.
History
Contributors
- Ordered by most recent
- Michael Tidmarsh62,220 pts.
- Denny Cherry68,390 pts.

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.

(This is the same answer that I posted here.)

Discuss This Question: 1 Reply

Gent01 Feb 24, 2010 10:10 PM GMT

If you database has rows deleted on a regular basis you might be able to compact the database and get enough space back to work with.

1,870 pointsBadges:

report