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 |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2003-12-18 : 11:19:56
|
| How can I view the recovery model that my datbase is currently using. As in if it is either FULL |BULK_LOGGED|SIMPLE . I am planning to change to FULL. If I apply the change to the model DB will it be automatically changed for all other databases?Thank youAll help appreciated. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-12-18 : 11:43:37
|
| In EM, right click the DB, and select properties, then select Options. No Changing it for Model will not affect existing DBs.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-18 : 12:22:55
|
| When you make changes to the model database, these changes will be made to any NEW databases, not ones that already exist. If you've got a lot of databases to change, use ALTER DATABASE in QA instead of EM.Tara |
|
|
|
Granick
Starting Member
46 Posts |
Posted - 2003-12-18 : 13:04:31
|
| I know that this is a little off topic, but do very many people make changes to the model database so that they can use the changes in new DBs? I haven't really needed to make DBs that were similar enough that it would really save me any work? Is that unusual?Just kind of wondering,Shannon |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-18 : 13:08:20
|
| I don't make changes to the model database. I know some people put stored procedures in there so they are automatically there for new databases. These stored procedures would be ones that are not application specific. I've seen 3rd party installations where they add users to it as well. I'm not sure why they don't just add the users to the user database on installation.Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-12-18 : 15:40:00
|
| One thing I can tell you, I looked at that screen this morning and clicked passed it. Glad you pointed it out to me. next time I will try going slowerAll help appreciated. |
|
|
|
|
|
|
Recovery model