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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2009-01-02 : 12:27:03
|
| Hi,I've one database which has recovery mode SIMPLE. Does chaning from SIMPLE to FULL required anythings to change?Does earlier backup no longer valid after changing recovery mode to FULL?Please advice what would be any impact?Thanks,-Dinesh |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-02 : 12:38:21
|
quote:
Originally posted by sqlserverdbam
Hi,I've one database which has recovery mode SIMPLE. Does chaning from SIMPLE to FULL required anythings to change?No.This will let you backup transaction log as well and everything will be logged .Does earlier backup no longer valid after changing recovery mode to FULL?Yes but restoring old backup will put your database in simple recovery model and you won't be able backup log. You need to do full backup after changing to FULL so you can create log chain with Transaction log backup.This will let you restore point in time.Please advice what would be any impact?Thanks,-Dinesh
|
 |
|
|
ghemant
Starting Member
22 Posts |
Posted - 2009-01-06 : 07:32:50
|
| Yes, and in addition to what Sodeep has suggested now as you have your database in full recovery model you should schedule a job to take T-Log backup at regular interval. It is always recommended to have databaes in Full recovery model in production envrionment so that you can have point-in-time recovery available.RegardsHemantgiri S. Goswamihttp://hemantgirisgoswami.blogspot.com/ |
|
|
|
|
|
|
BACKUP Question