Error Restoring Database

[jfokas]

I am trying to restore from a backup of SQL 7(SP4) database onto an instance SQL Server 2000 (SP3) and get the following error message:

MICROSOFT SQL-DMO (ODBC SQL State: 42000)

This version cannot redo any index creation or non-logged operation done by SQL Server 7.0 Further roll forward is not possible.

Location: Bckutil.cpp: 3222
Expression:m_Command == BcmdRestoreLog
SPID: 53
Process ID:1420


I had previously restored from the same backup file into same SQL version (2000 SP3) on a different without a problem.

Does anyone know what the problem is and what I can do about it? Your help is greatly appreciated!

John

 

[vongrunt]

Are you 100% sure this is the same backup?

Other than that, clear/shrink SQL7 transaction log and repeat backup... or use detach/attach.

 

[SQLBill]

This is a cross-post and is also in the MS SQL Server: Setup and Administration forum (THREAD962-984414), which is the more appropriate forum (IMO).

Please direct responses there, so that all responses are in one thread.

Thanks

-SQLBill

Posting advice: FAQ481-4875