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 |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2003-02-09 : 19:30:57
|
| HiyaIs there any issues that I need to be aware of in changing from SIMPLE to FULL RECOVERY on a live database (ie ALTER DATABASE ...)? Obviously, since it's simple at the moment, if there are any issues, I won't be able to "roll-back" (to any recent position anyway)...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
darinh
Yak Posting Veteran
58 Posts |
Posted - 2003-02-09 : 19:59:58
|
quote:
HiyaIs there any issues that I need to be aware of in changing from SIMPLE to FULL RECOVERY on a live database (ie ALTER DATABASE ...)? Obviously, since it's simple at the moment, if there are any issues, I won't be able to "roll-back" (to any recent position anyway)...--I hope that when I die someone will say of me "That guy sure owed me a lot of money"
I've done this a couple of months ago on SQL2K sp2 and it worked fine. Did a bit of research first on the web and didn't identify any real issues and then tried it on a test server then eventually on live. Obviously doing it straight after a full backup reduces your risk. One thing you might want to consider is backing up your transaction logs more often. If you have enough disk space, doing a restore to another database to make sure it worked is a good idea too.Can't remember if I had to stop and start SQL Server but I guess that'll be in BOLEdited by - darinh on 02/09/2003 20:02:32 |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-02-09 : 22:12:36
|
| Thanks DarinActually I can't find much in BOL on doing it live at all...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2003-02-09 : 23:21:01
|
| Hahaha......Hehehehe........Hihihihihi.......Sanjeev 'Tiger' |
|
|
|
srf
Starting Member
42 Posts |
Posted - 2003-02-09 : 23:53:28
|
| You should put that through test first. Full recovery can use a *lot* more log space than simple depending on what you're doing. |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-02-10 : 00:24:48
|
quote:
You should put that through test first. Full recovery can use a *lot* more log space than simple depending on what you're doing.
Presumably ...Next you'll be telling me you can't get something for nothing...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
FULL RECOVERY