Jump to content

Multiple Backup Sets for Same Data *Different Destinations*

Recommended Posts

Hello All,


Here is my situation, I am looking to Create one backup set which will backup my Sql Database to a hard disk on my network. For offsite purposes I would like to tke a DVD backup of those files offsite. My dilema is in the creation of the second backup set that will take the hard disk residing backup and burn it over to the DVD.


Currently the Grooming on the Hard Disk backup is set for 15 consecutive daily backups, but that will not fit on DVD. If in the second backup set I set it to groom per every backup will that only be what that particular set stores for restore purposes, or will my original to hard disk backups be destroyed?


My Assumption is that I should create a set that will run Daily and write data directly to the DVD, although I was just looking for way to not have to backup my Sql database twice daily freeing up some resources for end users.




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