Jump to content

Backing up SQL DB in multiple Backup Sets


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 just purchased the SQL Add on as we would like to start backing up a SQL Database. What would be the best strategy for adding the SQL to our current backup scheme. Currently we run to Backup Sets during the week. One that runs during the day and one at night. The one during the day is called Backup Set A and is finished before the office closes so that it can be taken home each night. The one during the night is called Backup Set B and is scheduled to run during the night. Both are set to Recycle every fortnight on alternating weeks. On Saturday however, we run a third backup set called Weekly Backup Set. This set is then archived, each month we will do a New Backup Set Backup.


Given that tape space is at a premium until we get an auto-loader next year we are looking to minimize the data on the tapes. Previously we have just been doing full backups of Exchange each day to each set. But I would like to possibly change this to Differential along with setting up a Differential with SQL, but what are the consequences in doing so when we have 3 different backup sets running?


For example. If I set Backup Set A and Backup Set B to do Differential Backups, and we need to restore the database from one of these sets will there be any potential issues? I have the same question for an Exchange Differential backup.


Any thoughts or tips on this matter would be greatly appreciated!




Link to comment
Share on other sites

Ok, so a somewhat decent nights sleep over this issue has made me come up with the following idea. Instead of backing up the SQL Databases twice to tape in the way I mentioned before I figured it might be better to:

- Backup the Database to Disk via a new backup set

- Full Backup once a week

- Differential backup each day and night for the the remaining part of the week

- Each day, transfer the backup set to tape to each of the backup sets mentioned before.


I think this will work much better, just is a bit mind boggling.


Let me know your thoughts.

Link to comment
Share on other sites

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