Restoring a database after migrating from SQL Server 7 to SQL Server 2005
Home > IT Answers > SQL Server > Restoring a database after migrating from SQL...
SQL Server Ask the Experts
2445 pts.
0
Q:
Restoring a database after migrating from SQL Server 7 to SQL Server 2005
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?
ASKED: Dec 30 2008  8:06 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Apickel
325 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Have you tried detaching the database from the 7 version, copying them to the 2005 version location and then attaching?
Last Answered: Dec 31 2008  12:26 AM GMT by Apickel   325 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Dec 30 2008  9:57PM GMT

Your RESTORE DATABASE looks fine. What happens when you run checkdb against the SQL 7 server that you took the backup from?

 
0