Post reply

Use "stopat"

  • September 25, 2003 at 3:22 am

    #83212

    Hi!

    A very short question: Is it possible to use "stopat" with differential restore?

    Thanx.

  • September 25, 2003 at 4:12 am

    #475758

    No.

    Diffential backups are data backups. It is the whole file or nothing.

    stopat only works with log backups

  • September 26, 2003 at 3:23 am

    #475943

    As long as you are not truncating the log on checkpoint (Recovery Model is not 'Simple' in 2000) and you have yet to restore your database you will still have the log data. Backup the log and then restore the last differential before the data loss/corruption with the 'Leave database nonoperational but able to restore additional transaction logs' option selected. Then you can restore to point in time from the log.

    The log is not lost even if you have done a full or differetial backup.

    If you are truncating the log I would recommend turning this option off, or setting Recovery Model to 'Full' in 2000, and adding a log backup to your maintenance plan. Even if you are not writing the log backups to tape having the backups on disk can save a lot of headaches!

Viewing 3 posts - 1 through 2 (of 2 total)

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