January 30, 2009 at 10:48 am
Currently, we do a FULL backup of all our production databases every night. I want to schedule an incremental backup that runs every day from 8am to 6pm, every 3-4 hours. So that when there is a crash at 7pm, we can restore previous night's full backup and incremental backups from 8am - 6pm.
How can i schedule a job for this incremental backup?
Please provide me with any scripts that you might have got...
February 3, 2009 at 2:28 pm
You do this the same as you do for a full backup, but you add the DIFFERENTIAL option
http://technet.microsoft.com/en-us/library/aa238405(SQL.80).aspx
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 3, 2009 at 2:33 pm
I'm going to suggest that you read BOL again. Read about Full, Differential, and Transaction Log backups. What types and how often you run the various backups is dependent on your business requirements and the recovery model of your database(s). Any databases using bulk-logged or full recovery model should have periodic transaction log backups run to keep the size of the transaction logs manageable.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply