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 |
|
poratips
Posting Yak Master
105 Posts |
 Posted - 2013-06-03 : 16:19:47
|
| Hi,My client having Full backup every night but it's set up FULL Recovery model, I have a question that if they are taking back up every night and looks like they will b ok with this but is it any benefits having Recovery Model leaving as default as FULL instead of SIMPLE as they don't have any Differential or T-Log back up?I am just wondering if they are not using any Differential or T-Log back up and only taking daily Full Backup then it should be advisible set up Recovery Model as Simple instead of default?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-06-03 : 16:25:46
|
| If not taking tran log backups, should definitely switch it to simple. Else, eventually, the log will grow out of control. |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-03 : 16:46:03
|
| To add to what russell said, another consideration is that if they are using database mirroring, it requires full recovery model. Another problem that I have run into, which you are unlikely to, is that if your transaction log backup job is set up to take log backups of all user databases and if some of those are in simple recovery model, the job will fail - because tran log back up is not a supported operation in simple recovery model. |
|
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-06-03 : 17:16:48
|
| Thanks both of you Russell and James.We are not taking T-Log or even Diff Backup.If we use Snapshot then it will affect if w switch to SIMPLE> |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-03 : 18:26:38
|
quote:
Originally posted by poratips
Thanks both of you Russell and James.We are not taking T-Log or even Diff Backup.If we use Snapshot then it will affect if w switch to SIMPLE>
Any recovery model including SIMPLE will work. |
|
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-06-04 : 23:49:03
|
| Thanks. |
|
|
|
|
|
|
Recovery Model