Solved

Restoring MSSQL2000 .bk file to MSSQL2005

Posted on 2011-09-15
7
513 Views
Last Modified: 2012-11-19
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.
0
Comment
Question by:TATech
  • 3
  • 2
  • 2
7 Comments
 

Author Comment

by:TATech
ID: 36546029
Here's the process I went through:

Right click Databases
Restore Database
From Device: File
Select File
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36546309
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
 

Author Comment

by:TATech
ID: 36546794
Unfortunately I don't have as much access to the SQL2000 at this time.
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:TATech
ID: 36546795
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
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36546877
Try restoring to a New Database ... I just noticed you are right-clicking on an existing one and selecting restore.
0
 
LVL 9

Expert Comment

by:sachinpatil10d
ID: 36547734
check the compatibility level when creating a new database.
compatibility level should be set to SQL Server 2000
0
 
LVL 9

Accepted Solution

by:
sachinpatil10d earned 500 total points
ID: 36547740
try this settings
compatibility level should be set to sql server 2000
NewDatabase-Settings.png
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question