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 |
|
blakmk
Starting Member
45 Posts |
 Posted - 2003-04-04 : 09:32:19
|
| Does anyone know how to change the default datfile/logfile log directory without reinstalling sql server? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-04-04 : 14:08:54
|
| In SQL2000 you can specify this using EM - Server>Properties>Database Settings. Can't remember if this was available in SQL7 but you can do it just the same by changing the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer and adding (if they don't exist) new string values for DefaultData and Default Log. If you mean move all the structures then check out [url]http://www.sqlteam.com/item.asp?ItemID=10061[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
Default datafile location