?
Solved

Restoring MSSQL2000 .bk file to MSSQL2005

Posted on 2011-09-15
7
Medium Priority
?
531 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 60

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 60

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 2000 total points
ID: 36547740
try this settings
compatibility level should be set to sql server 2000
NewDatabase-Settings.png
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

840 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