Post reply

SQL 2K - Database differential restore problems from Backup Device

  • July 7, 2004 at 5:33 pm

    #111821

    Hello,

    I'm in desparate need of help. I'm trying to restore a differential backup taken from yesterday but I keep getting an error telling me that I need to specify WITH NORECOVERY or WITH STANDBY and to restart the restore sequence. I've tried to do this using:

    EM:

    Right click DB > select Restore > From Device > add Device > view content > select file > click OK

    Transact SQL:

    use master

    restore database abs_workspace

    from daily_incr_abs_workspace_bkup

    with file = 10,

    norecovery

    Error:

    Server: Msg 4306, Level 16, State 1, Line 2

    The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.

    Server: Msg 3013, Level 16, State 1, Line 2

    RESTORE DATABASE is terminating abnormally.

    I've tried putting the database in single user mode because when I run it using TS from the database "abs_workspace", I get an error indicating the DB is in use. If anybody can help with this problem would be great. I need to restore the backup by tomorrow morning.

    thanks in advance!!!!!!!!

  • July 7, 2004 at 8:38 pm

    #513773

    To restore a differential backup, the database itself must be in a RESTORING state i.e. the restore operations before this must have restored the database with the NORECOVERY or STANDBY options.

    You cannot just restore a differential backup onto your existing database.  You must at least restore a full database backup with either of the above options, and then only can you restore the differential backup.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • July 8, 2004 at 6:13 am

    #513829

    I LOVE THIS FORUM!!!!

    Thanks Peter, that worked by installing the full backup first and then each incr with the NORECOVERY until I got to the last incr and used RECOVERY.

    If I keep this up, I might grow up to be a DBA one day.

    Thanks again

    Ronnie

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

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