| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-10-26 : 12:49:43
|
| I once read that I can chnage the file path of the LDF and MDF files for the model database and it would cause the default path for all new databases files to be in that directory as well.If this is true, how do I change the path for the current model database files?All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-26 : 14:46:02
|
| On the Database Tab on the Server Properties you can set the Default directories for Data and Log.( Have never tried any of that myself though )rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
 |
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-10-26 : 15:31:24
|
| Rockmouse, Try it please. I tried and it never worked. Also tried the sp_detach.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-26 : 15:37:22
|
| What did you try? Did you right click on your server, go to properties, then to database settings? That's what rockmoose was referring to. That's the GUI for modifying the registry entries that I referred to. Tara |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-26 : 15:56:27
|
quote:
Originally posted by rohans
Rockmouse, Try it please. I tried and it never worked. Also tried the sp_detach.All help appreciated.
Hi, it worked if I restarted the SQL Server Service.Don't use a trailing \ in the path, because it puts that in as well:C:\newdatadir\ <--/rockmoose |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-10-26 : 16:34:45
|
| Her is what I did.Right click on model database. go properties. then I see a small window with 5 tabs. General, data file, transaction file,Filegroups,options,permissions. when I select data file and try changing it I cannot.What should I try next.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-26 : 16:35:45
|
| rohans, you aren't following what we are saying. Don't right click on model. Right click on the server in EM, go to properties, then to database settings tab.Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-10-27 : 12:04:38
|
| Thank you, I now got it locked and under control.All help appreciated. |
|
|
|
|
Config the model database