How to Restore SQL2K Full bkup then tran logs?

I am upgrading from SQL2000 to SQL2005 - I want to restore a full SQL2000
backup, then the transaction log backups to 2005. Am getting error below w/
full in standby - How to resolve? Thanks.

RESTORE DATABASE [MyDB] FROM DISK =  N'\\srvimgdb2\bkData
\MyDB.bak'
WITH FILE = 1, NOUNLOAD, STATS = 10, STANDBY =  N'E:\dbData\standbyM
yDB.txt',
REPLACE,
MOVE N'MyDB_Data' TO  N'E:\dbData\MyDB_Dat
a.mdf',
MOVE N'MyDB_Log' TO  N'C:\dbLogs\MyDB_log
.ldf'


Msg 3180, Level 16, State 1, Line 2
This backup cannot be restored using WITH STANDBY because a database upgrade
is needed. Reissue the RESTORE without WITH STANDBY.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

Chris  wrote:
> I am upgrading from SQL2000 to SQL2005 - I want to restore a full SQL2000
> backup, then the transaction log backups to 2005. Am getting error below w
/
> full in standby - How to resolve? Thanks.
>
> RESTORE DATABASE [MyDB] FROM DISK =  N'\\srvimgdb2\bkData
\MyDB.bak'
> WITH FILE = 1, NOUNLOAD, STATS = 10, STANDBY =  N'E:\dbData\standbyM
yDB.txt
',
> REPLACE,
> MOVE N'MyDB_Data' TO  N'E:\dbData\MyDB_Dat
a.mdf',
> MOVE N'MyDB_Log' TO  N'C:\dbLogs\MyDB_log
.ldf'
>
>
> Msg 3180, Level 16, State 1, Line 2
> This backup cannot be restored using WITH STANDBY because a database upgra
de
> is needed. Reissue the RESTORE without WITH STANDBY.
> Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.

Try WITH NORECOVERY instead of WITH STANDBY


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com