Restoring MSSQL2000 .bk file to MSSQL2005

I am attempting to restore a MSSQL2000 .bk file to a local instance of MSSQL2005, but seem to be getting a header error:

 Screen-shot of error.
TATechAsked:
Who is Participating?
 
sachinpatil10dConnect With a Mentor Commented:
try this settings
compatibility level should be set to sql server 2000
NewDatabase-Settings.png
0
 
TATechAuthor Commented:
Here's the process I went through:

Right click Databases
Restore Database
From Device: File
Select File
0
 
Kevin CrossChief Technology OfficerCommented:
Do you have the SQL 2000 system still up and running? Maybe you can trying doing the BACKUP again. Try picking a name without special characters just in case and use .BAK extension, i.e., DB20110915.BAK. Probably not the issue, but to be safe. While doing the BACKUP, please ensure that the backup type is FULL and component selected is DATABASE.

References (if needed):
BACKUP: http://msdn.microsoft.com/en-us/library/ms187510(v=SQL.90).aspx
RESTORE: http://msdn.microsoft.com/en-us/library/ms177429(v=SQL.90).aspx
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
TATechAuthor Commented:
Unfortunately I don't have as much access to the SQL2000 at this time.
0
 
TATechAuthor Commented:
I'll try to go through the restore process with the link you gave - perhaps there's a little more detail I missed.  I'll post here as soon as I can.
0
 
Kevin CrossChief Technology OfficerCommented:
Try restoring to a New Database ... I just noticed you are right-clicking on an existing one and selecting restore.
0
 
sachinpatil10dCommented:
check the compatibility level when creating a new database.
compatibility level should be set to SQL Server 2000
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.