I am trying to migrate from SQL Server 7 to SQL Server 2005, but when I try to restore the database I get this error:
"Processed 120424 pages for database 'COAST', file 'Coast_Data' on file 1.
Processed 1 pages for database 'COAST', file 'Coast_Log' on file 1.
Converting database 'coast' from version 515 to the current version 611.
Database 'coast' running the upgrade step from version 515 to version 521.
Msg 3167, Level 16, State 1, Line 4
RESTORE could not start database 'COAST'.
Msg 3013, Level 16, State 1, Line 4
RESTORE DATABASE is terminating abnormally."
The code I am using is:
RESTORE DATABASE COAST
FROM DISK = 'C:program filesmicrosoft sql serverMSSQL.1mssqlbackupBACKUP.BAK'
MOVE 'COAST_DATA' TO 'C:program filesmicrosoft sql serverMSSQL.1mssqldataCOAST.MDF', MOVE 'COAST_LOG' TO 'C:program filesmicrosoft sql serverMSSQL.1mssqldataCOAST_LOG.LDF'
Do you have any idea what I am doing wrong?
December 30, 2008 8:06 PM
December 31, 2008 12:26 PM