Problem Restoring Diff Backup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Problem Restoring Diff Backup

Author

Topic

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-10-29 : 19:08:40

I have the following backups on server1

Full 5AM
Log1 5:15 AM
Log2 5:30 AM
Log3 5:45 AM
Diff 6:00 AM

I'm trying to restore the database on server2 up to 6:00AM

So I go to enterprise manager-->all tasks-->restore
In General Tab
Select From Device and choose Full
Select Database Complete
In Options Tab
Select Leave Database Non-Operational

This part works ok
Next I go to restore the diff

In General Tab
Select From Device and Choose Diff
Select Database - differential
In Options Tab
Leave Database Operational.

I get an error "Cannot apply backup on device"

What am I doing wrong???

Here is how the backups were created.
Full Backup:
BACKUP DATABASE [MyDB] TO DISK = 'c:\Full' WITH INIT , NAME = N'MyDB FullBackup', SKIP , STATS = 10, NOFORMAT

Diff Backup:
BACKUP DATABASE [MyDB] TO DISK = 'c:\Diff' WITH INIT, DIFFERENTIAL, NAME = N'MyDB DiffBackup', SKIP , STATS = 10, NOFORMAT

Log Backup:
BACKUP LOG [MyDB] TO DISK = 'c:\Log' WITH INIT, NAME = N'MyDB Log Backup', SKIP , STATS = 10, NOFORMAT

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-10-30 : 13:56:08

Valter,

It sounds like maybe the first restore actually did a WITH RECOVERY (leave database OPERATIONAL instead of NON-OP). Or perhaps something else you did triggered a recovery. That would cause you problems in trying to apply the second RESTORE.

I'd suggest scripting the RESTORE commands directly instead of using Enterprise Manager, and that way you know exactly what's going on.

HTH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources