Thursday, February 16, 2012

Changing folder for databases to reside in?

Can I change the folder that the databases reside in for my installation of SQL Server? I would like to have them in a folder on another drive, but I can't seem to find where the path is configured.
Any help is appreciated.I don't think you can because all SQL Server files are in Microsoft SQL Server folder under programs in the C drive but I am not a networking person so you may get a better answer. I am assuming you could tell setup to put the folder in a different drive during installation but I could be wrong. Hope this helps.|||When restoring the Database you can select the folders to use in the options tab.
I am 95% sure you can not change the folders after restoring.
Mathias|||Ok, thanks for the information!|||In Enterprise Manager, open the property dialogue for your Sql Server Instance. Click the "Database Settings" TAB. You'll see "New database default location". Use this to set a new locations for DataBases and Logfiles. Next time you create a DB, it will be created in this Directory.
I believe it's possible to backup and recreate all your database to the new location.
NOT FOR THE FAINT OF HEART

You will need to change the "startup parameters" to point to the new location of the Master DB, ErrorLog and MastLog files after recreating them in the new location. This is done at your own risk. I am not even sure if it is possible to move the MASTER etc.
NOT FOR THE FAINT OF HEART

No comments:

Post a Comment