Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
bteoman
Starting Member
1 Post |
Posted - 2006-08-26 : 09:56:34
|
Hi.I use Microsoft SQL Server. I wanna change the location where databases is saved. Default location is C:\Program Files\Microsoft SQL Server\MSSQL\Data. How can i change this?Thank u in advance. |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-08-26 : 14:14:29
|
Change location in 1. Creating a new databaseor2. Existing database ? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-26 : 21:56:08
|
to change the default folder location for data & log file, use Enterprise Manager. Right click on the SQL Server and select property and select Database Settings. Change the Default Data & Log Directory. KH |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-08-27 : 04:21:23
|
If you want to change location of existing database, then you can detach and move the file to the new location and reattach back. Or simply backup and restore (using move statement).Hope this one help. |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2006-08-28 : 07:31:59
|
http://www.sqlservercentral.com/columnists/chedgate/movingsystemdatabasesachecklist.aspThis a good article for see how to change the Default location where Databases are created. |
|
|
|
|
|