Solved

Restoring MSSQL2000 .bk file to MSSQL2005

Posted on 2011-09-15
7
503 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
Comment Utility
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
Comment Utility
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
Comment Utility
Unfortunately I don't have as much access to the SQL2000 at this time.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:TATech
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
try this settings
compatibility level should be set to sql server 2000
NewDatabase-Settings.png
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now