Post reply

Restore Database From Overwritten Old Backups

  • October 10, 2013 at 12:59 pm

    #283678

    Hi Every one..

    Like to take advise on this.

    Have one backup file which overwritting everyday full backup on that file Suppose ADW.Bak overwritting Full Backup every day .I want to restore Database with 5 day old backup file how i can do that?

    When i am trying to restore it showing me most current backup file only?

  • October 10, 2013 at 1:01 pm

    #1657697

    Was the backup overwriting the older backups in the file every night or appending the backup to the file?

    Restore headeronly should show you what backups are in the file.

    If there's only one backup in the file, then you can only restore from that. If backups are being overwritten then the older backups are gone.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 10, 2013 at 1:40 pm

    #1657709

    Its Overwritting with INIT and NOFORMAT Option.

    Restore Headeronly showing most current backup file which todays date..

  • October 10, 2013 at 1:42 pm

    #1657711

    this is the command

    BACKUP

    DATABASE XXX.bak TO DISK = N'F:\Backup\XXX.bak' WITH NOFORMAT, INIT, NAME = N'XXX_backup_2013_10_10_153518_8403533', SKIP, REWIND, NOUNLOAD, STATS = 10

    GO

  • October 10, 2013 at 2:10 pm

    #1657725

    logicinside22 (10/10/2013)

    Its Overwritting with INIT and NOFORMAT Option.

    Restore Headeronly showing most current backup file which todays date..

    That's because INIT deletes old backups from the file before starting the new backup. There's no other backups than the latest in that file, so that's all you're going to be able to restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 10, 2013 at 2:18 pm

    #1657732

    Thanks a lot Gail . your information always best .

  • October 11, 2013 at 2:06 am

    #1657820

    You don't have e.g. an offsite backup that takes a copy of your backup file every night, do you? If so you could possibly restore that.

Viewing 7 posts - 1 through 6 (of 6 total)

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