December 2, 2005 at 1:34 pm
We use a removeable harddrive system to do offsite backup on a large 70gb database. The Uses do one full on friday and diffs mon-thru this is done with a app I wrote using sql to do the backups. We also schedule a full on friday night stored on a local hard drive and diffs mon-thru.
Here is the problem we tried to restore from the removeable hard drive using the removeable diffs but because the schedule full was done after the removeable the diff's would not restore. We need a fail safe because the removeable system is an app the users have to run and sometimes they forget to run it. By the way the database is simple.
just so you know i'm not a dba but this got dumped in my lap
hope someone can help.
Thanks
Mike
December 2, 2005 at 1:45 pm
You should set your backups to be done as jobs in SQL Server.
If you MUST have the app do it, the app should have a way to schedule the backups for specific days and times. If not, try a cron job that runs the apps backup commands.
-SQLBill
December 2, 2005 at 4:44 pm
To add...
If you're going to use the app, have the app check what type of backup has been done previously. Determine if you have a full or a differential and take the appropriate type to keep yourself in synch.
Your friendly High-Tech Janitor... 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply