I have a full Backup and a diff backup on a SQL 7 database
I have restored the full backup with NORECOVERY option sucessfully in a SQL
2000 server
When i try to restore the diff backups its gives me a error
Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device 'Z:\MS SQL
SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak' to database 'AVAWEB'.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
-- Here is the command i am running
RESTORE DATABASE AVAWEB
FROM DISK = 'Z:\MS SQL SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak'
WITH FILE=1, NORECOVERY,
MOVE 'AvaWeb_Data' to 'Z:\MS SQL SERVER\data\avaweb_data.mdf',
MOVE 'AvaWeb_Log' to 'Z:\MS SQL SERVER\log\avaweb_log.ldf'
Are you certain that you didn't perform a database backup between that db backup and the diff backup
you are trying to restore. I'd check in the backup history tables in msdb just to be certain.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:F22E8045-3B2D-429C-BB59-754079897F49@.microsoft.com...
>I have a full Backup and a diff backup on a SQL 7 database
> I have restored the full backup with NORECOVERY option sucessfully in a SQL
> 2000 server
> When i try to restore the diff backups its gives me a error
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'Z:\MS SQL
> SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak' to database 'AVAWEB'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> -- Here is the command i am running
> RESTORE DATABASE AVAWEB
> FROM DISK = 'Z:\MS SQL SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak'
> WITH FILE=1, NORECOVERY,
> MOVE 'AvaWeb_Data' to 'Z:\MS SQL SERVER\data\avaweb_data.mdf',
> MOVE 'AvaWeb_Log' to 'Z:\MS SQL SERVER\log\avaweb_log.ldf'
>
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment