SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Recovery Model
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

poratips
Posting Yak Master

104 Posts

Posted - 06/03/2013 :  16:19:47  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 06/03/2013 :  16:25:46  Show Profile  Visit russell's Homepage  Reply with Quote
If not taking tran log backups, should definitely switch it to simple. Else, eventually, the log will grow out of control.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3699 Posts

Posted - 06/03/2013 :  16:46:03  Show Profile  Reply with Quote
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.
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 06/03/2013 :  17:16:48  Show Profile  Reply with Quote
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>
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3699 Posts

Posted - 06/03/2013 :  18:26:38  Show Profile  Reply with Quote
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.
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 06/04/2013 :  23:49:03  Show Profile  Reply with Quote
Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000