July 10, 2012 at 6:50 am
hi,
We can take the tlog backup of the databases 'model'.... but not for 'master', 'msdb' and 'model' even after changing the recovery model?
Thanks.
July 10, 2012 at 6:59 am
Master no, it can only ever be in simple recovery model, no matter what you set the recovery model to.
Model, yes you can take log backups, why would you bother?
MSDB, yes, you can take log backups, is your job and backup history critical enough to require them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2012 at 7:21 am
GilaMonster (7/10/2012)
MSDB, yes, you can take log backups, is your job and backup history critical enough to require them?
Gail correct me if i am wrong wont the daily full backup suffice the purpose still, if in case huge update happens log backup may help.
Regards
Durai Nagarajan
July 10, 2012 at 7:27 am
Don't understand what you're asking.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2012 at 8:00 am
For MSDB, the daily full backup will suffice the pupose of securing the necessary data, why tlog is necessary? am i clear now..
Regards
Durai Nagarajan
July 10, 2012 at 8:04 am
Depends on how critical you consider your backup history, job history, etc. Some people consider it critical enough to want full recovery and log backups, some don't.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply