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 |
|
dev2dev
Starting Member
48 Posts |
 Posted - 2008-03-31 : 03:23:53
|
| Hello,Do I need to restart service after I set recovery option"ALTER DATABASE SET RECOVERY XXXX"can i specify RECOVERY OPTION in CREATE DATABASE?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 09:29:49
|
| Are you talking about Recovery Model? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-03-31 : 09:43:22
|
| >> Do I need to restart service after I set recovery optionno.You might need to take a full backup to get tr logs though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
dev2dev
Starting Member
48 Posts |
Posted - 2008-04-02 : 02:52:18
|
| Thx nr,Can I specify RECOVERy option in CREATE DATABASE? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-02 : 03:13:34
|
| Nope - it gets the recovery model from the model database which be default (wrongly imho but ms won't change it) is full.I always set model to simple when I install a server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
recovery option