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 |
|
mb
Starting Member
16 Posts |
 Posted - 2002-07-09 : 06:47:03
|
| Does anyone know how to change the Default data file and loggroup directory after installation. Without rebuilding the master database. |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-09 : 07:43:54
|
| You can do this in Enterprise managerRight click on the Server, choose Properties and click on the Database settings tab. You'll see where you can change these settingsAlso registry keys are HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[Instance Name]\MSSQLServerDefaultDataDefaultLogHTHJasper Smith |
 |
|
|
gwhiz
Yak Posting Veteran
78 Posts |
Posted - 2002-07-09 : 16:09:04
|
| Note this will only work in SQL2000 or if you are using the SQL2000 tools. Otherwise you will have to edit the registry values. |
|
|
|
|
|
|
Default data file and loggroup directory