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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!