Jump to content
pjscott13

SQL Server Backup Options

Recommended Posts

Hi All,

 

We are running Retrospect Multi Server Version 7.5.387 with Driver Update and Hot Fix Version 7.5.13.100 on a Windows 2003 Server.

 

We have the SQL Server add-on and I have been backing up DB's with out any issues. I have noticed however that our Log files are becoming quite large. In investigating the issue it appears I may not be backing up our DB's correctly.

 

I have not done a log backup, which explains the problem. I currently do a full backup once a week and differential backups for the rest of the week.

 

I read a post on this forum suggesting that a log backup should be done immediately after the full backup. http://forums.dantz.com/ubbthreads/showflat.php/Cat/0/Number/48525/an/0/page/5#Post48525

 

My question is should I be running a log backup instead of the differential or should i be including a log backup with the differential or should i do a full backup immediately followed by the log backup and just continue differential backups for the rest of the week? What are others doing in this situation?

Share this post


Link to post
Share on other sites

Ok, so it seems I have to provide my own advice on this forum. Can someone please look over this schedule and tell me if it will work and not cause any problems... in particular when it comes to restoring:

 

- Monday Morning Full SQL Backup (Recycle)

- Weekdays Mon-Fri During Day Every 4 hours Log Backup (Normal)

- Weekdays Mon-Fri Night Differential SQL Backup (Normal)

 

Cycle repeats itself for the next week. What are some examples of schedules that you are doing?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×