Error Attempting to Restore Database

[jfokas]

I am trying to restore from a backup of a 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!

 

[dalv]

It seems that sort order for both the servers is
different.
Compare the sort order of both the machines using
"sp_helpsort" stored procedure.

If u find any changes, u have to rebuild master
database using "RebuildM" utility that comes in SQL
Server CD.
Note: Before rebuilding the Master DB, check the notes
in SQL Books Online as this is critical.

 

[SQLBill]

This is a cross-post. It is also in Thread183-984385. This is the more appropriate forum for the question.

jfokus,

Please do not cross-post. Thank you.

-SQLBill

Posting advice: FAQ481-4875