[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


Restoring MSSQL2000 .bk file to MSSQL2005

Posted on 2011-09-15
Medium Priority
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.
Question by:TATech
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2

Author Comment

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

Right click Databases
Restore Database
From Device: File
Select File
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

Author Comment

ID: 36546794
Unfortunately I don't have as much access to the SQL2000 at this time.
Industry Leaders: 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

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.
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.

Expert Comment

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

Accepted Solution

sachinpatil10d earned 2000 total points
ID: 36547740
try this settings
compatibility level should be set to sql server 2000

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

650 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