Incremental Backup Job

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

  • 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

  • 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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply