I installed Standard Edition on a server with a 500 GB drive. Now the system is giving me error message of disk space is not available, so I added a new hard disk. How can I tell SQL Server to start using disk space from the new drive.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com May 20 '13 at 13:38
This question came from our site for professional and enthusiast programmers.
I'd suggest instead that you just move the database to the new, bigger drive. In addition to avoiding the complexity of splitting your database across multiple drives, you also free up disk space for the other databases that will stay on the original disk.
First, execute the following:
In most cases you should get two rows here, one for the data file, one for the log file (you can tell which is which by the
Then, in a period of downtime:
This is a little more work but a lot safer than detach / attach. Primarily because if something goes wrong with the restore, you still have the backup and/or the original database. If something goes wrong during the attach, you have 0 copies of your database.