| Author |
automatically set database to simple recovery upon creation
|
|
| mp3nomad 2006-02-10, 11:23 am |
| Is there a way to set the recovery model of any new databases created on SQL
Server 2005 to Simple instead of Full? I would like the recovery model to
default to Simple for any new databases created on the server.
Thanks for your help!
| |
| Tibor Karaszi 2006-02-10, 11:23 am |
| Recovery model is inherited from the model database. So you can set model to simple.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"mp3nomad" < mp3nomad@discussions
.microsoft.com> wrote in message
news:4B63FB22-E1A0-4E8F-895E- 75E25FD089AA@microso
ft.com...
> Is there a way to set the recovery model of any new databases created on SQL
> Server 2005 to Simple instead of Full? I would like the recovery model to
> default to Simple for any new databases created on the server.
>
> Thanks for your help!
| |
|
|
|
|