May 9, 2003 at 10:25 am
I want to change my data file location from C:\SQL_Data to E:\SQL_Data.
How does one accomplish this? I see no options from within Enterprise.
May 9, 2003 at 10:52 am
You can change the default, but if you want to actually move the databases, that's more of a manual process. To change the default path, do the following from inside Enterprise Manager:
1. Connect to server
2. Right-click on server and choose Properties from the pop-up menu.
3. Click on the Database Settings tab.
4. Enter the new Default data and log directories.
5. Click OK.
If you're looking to move around user databases, look at Andy Warren's articles on moving databases between servers... specifically anything dealing with de-attaching and re-attaching databases. Just you won't be copying the files from one server to another, rather one drive to another. System databases, look at Steve Jones' articles.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 9, 2003 at 10:59 am
I'm using SQL 7.0
The Database Setting tab has 3 sections:
Settings, Backup/Restore, Recovery.
The only option under Settings is Default Index Fill Factor.
I do not see a Default data directory.....
May 9, 2003 at 10:59 am
I'm using SQL 7.0
The Database Setting tab has 3 sections:
Settings, Backup/Restore, Recovery.
The only option under Settings is Default Index Fill Factor.
I do not see a Default data directory.....
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply