Jump to content

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 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?

Link to comment
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?

Link to comment
Share on other sites

  • 6 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...