Restoring a database after migrating from SQL Server 7 to SQL Server 2005

Tags:
SQL Server 2005
SQL Server 7.x
SQL Server migration
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: USE MASTER RESTORE DATABASE COAST FROM DISK = 'C:program filesmicrosoft sql serverMSSQL.1mssqlbackupBACKUP.BAK' WITH REPLACE, 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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have you tried detaching the database from the 7 version, copying them to the 2005 version location and then attaching?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Your RESTORE DATABASE looks fine. What happens when you run checkdb against the SQL 7 server that you took the backup from?
    66,010 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following