Restore from .Bak file issue in SQL Server 2000

5 pts.
Tags:
.bak file
Microsoft SQL Server 2000
First off thanks for reading, I am new to SQL (SQL Server 2000). Unfortunately 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. Unfortunately I keep getting errors like "Microsoft SQL_DMO "ODBC SQLState: 4200" "An internal inconsistency error has occurred. Contact technical support for assistance. Restore Database is Terminating abnormally." Anyone have any suggestions on how to get around this error or how to correctly restore a database from a .BAK file.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi, selli28,

Welcome in ITKE…….. Use a manual process

  • Right-click the \”Databases\” folder in the Object Browser and click \”Restore Database…\” in the menu that appears.
  • Select the database name (or enter the name if it does not already exist) in the \”To database\” drop-down menu.
  • Select the \”From device\” option and click the button with the \”…\” symbol.
  • Click the \”Add\” button and navigate to the folder on the server where the BAK file is located.
  • Double-click the BAK file and then click the \”OK\” button.
  • Check the \”Restore\” checkbox and click \”OK\” to restore the database from the BAK file.

If this method does not helps you then try:  SysTools SQL Backup Recovery

Thanks & Regards

Clark Kent

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Can you provide some more details on your server? How is it configured? Disk configuration? Has it been virtualized?
    135,525 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: