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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2003-01-10 : 09:12:54
|
| Just attended a Disaster Recovery meeting with Mike Hotek. He said that he always creates a seperate file group for user data and leave primary with the system tables, procs, views. I agree with this and I am trying to implement it.However, he also said you can change the model to do this so when you create another db this is already there. The issue is you cannot create user defined file groups on model. Has any one accoplished this before? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-10 : 09:35:01
|
| I couldn't do it either, using both EM and QA with ALTER DATABASE.Something tells me that if you played around with the settings in sysdatabases, you might be able to trick it into adding a second filegroup. I SURE AS HELL wouldn't try it myself, and I think if Mike didn't go into detail about it, it's probably a very risky move. I think you should contact him to find out exactly how he did it. |
 |
|
|
|
|
|
Adding filegroups to model