September 26, 2008 at 9:42 am
I was wondering whats the difference from creating a maintenance plan to back up your db than using a backup device?
Also can you create a differential backup through a maintenance plan? If not how would you create it through a device backup that would delete old backup files?
I'm thinking you have to create a device for each day of the week and then set it's expiration date but that could be a lot of work. My other thought is to set the weekly Full backup by the maintenance plan and place the differential backup device .bak files in the same folder which would then clear out old .bak files.
September 26, 2008 at 11:25 am
First, maintenance plans and devices aren't related. They're different concepts. You can use devices with or without maintenance plans. Note I don't recommend devices. They're a hold over from older versions and I see no reason not to use database disk file backups.
Second, the maintenance plans make things easy. They do not do diff backups, so you'd have to build your own script to do those.
I prefer using my own scripts, mainly because I can check for things like suspect DBs, offline, single user, etc. and take action. The maintenance plan is very basic.
There are lots of backup scripts here on the site you can use if you want to try your own backup system.
September 26, 2008 at 12:33 pm
Thanks for the input... depending I might attempt to adapt one of the scripts out there if we get serious on making the production server a differential. Overall, we want to test out setting up a differential backup for our dev database instead of . So should I just be backing up my differential without a device? Or would the device suffice instead of making a script.
other than that... keep up the great daily editorials!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply