Solved

Restoring MSSQL2000 .bk file to MSSQL2005

Posted on 2011-09-15
7
519 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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