Solved

Restore From .Bak file trouble.

Posted on 2004-04-11
10
1,773 Views
Last Modified: 2008-02-01
First off thanks for reading, I am new to SQL (SQL Server 2000). Unfortunatley I just had the array my Data was on and my tape backup get toasted, I was able to do some data recovery on the remaining drives and pull off about 15 different .bak files for the database I need to restore. Unfortunatley I keep getting errors like "Microsoft SQL_DMO "ODBC SQLState: 4200" "AN internal inconsistancy error has occurred. Contact technical support for assistance. Restore Database is Terminating abnormally." Anyone have any suggetions on how to get around this error or how to correctly restore a database from a .BAK file.

Thanks again
0
Comment
Question by:tekguy4
  • 5
  • 4
10 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 10803212
Did you have to rebuild/reinstall the SQL Server?  Make sure that the version of SQL Server that was used to create the BAK file is less or equal to the version of SQL Server you're trying to RESTORE on.

Try this command in query analyzer and see what the results are:

RESTORE HEADERONLY from  disk='c:\yourbackup.bak'

Of course, change c:\yourbackup.bak to the correct path, filename of your backup.

This command will display the information that's contained in the backup.  Including the original SQL Server version information.  If this command doesn't run, there is a very good chance that the backup is corrupt.
0
 

Author Comment

by:tekguy4
ID: 10804929
Thanks for the first tip, the command runs fine and it returns all the information. I am going to try reinstalling SQL and keep this port up to date, if anyone else has any hints or suggestions, please, please feel free to respond.

Thanks again
0
 
LVL 34

Expert Comment

by:arbert
ID: 10804968
I wouldn't reinstall SQL.....Unless you think part of the program files were on the RAID group that got corrupted....
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Expert Comment

by:MrDeveloper
ID: 10805775
You're not by any chance trying to restore a sql 2K database backup in sql 7, are you?  If you do that, it gives a confusing error similar to that one
0
 

Author Comment

by:tekguy4
ID: 10805877
Yeah they where, I can get the bak file to restore the ldf and mdf file, but it leaves me hanging, if you go to enterprise manager, it shows the database as (Loading/Suspect)  or just  (Loading) depending on the file I use to restore, and it seemd to hang there.

Anyone have any thoughts on getting around this???

Thanks again
0
 

Author Comment

by:tekguy4
ID: 10805907
No, SQL2000 (server and bak file), I can return header information, I can get a file list, and I can get a file recovery all using Query Analyzer, but it hangs, as stated previously.



0
 
LVL 34

Expert Comment

by:arbert
ID: 10805923
"Thanks for the first tip, the command runs fine and it returns all the information."

Like I said above, make sure that the version information in the backup file matches the version information  of the current sql server (current version can be found by execute select @@version in query analyzer).

Are you creating the restore command yourself in query analyzer?  Enterprise manager?  Using third party backup/restore?    Make sure you you use the WITH RECOVERY option if you're not restoring any log file backups or the database will stay in a "loading" state.
0
 

Author Comment

by:tekguy4
ID: 10806139
sorry for not putting that info in, SQL 2000 ver 8.00.818 on both sides, server and file.
I am creating the restore command myself in query analyzer not using any third party software. Using the follwoing statement in query analyzer:
restore database databasename from disk = 'c:\databasename.bak'
with recovery
I get the following message:
Server Msg 3270, level 16, state 1, line 1
AN internal inconsistancy error has occurred. Contact technical support for assistance.

Thanks again for your help.
0
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 10806435
Well, if the version do match, I would say you have a corrupted backup file.   Do you have a support contract with MS?  They do have tools that we don't have access to.
0
 

Author Comment

by:tekguy4
ID: 10807755
yeah thats what I was afraid of anyone know of any recovery service for a corrupt .bak or .mdf file?
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Abstract Express Replacement Software 12 22
SqlServer no dupes 25 34
convert null in sql server 12 31
Update a text value in another table 10 35
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

815 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