Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Problem with RESTORE

Problem with RESTORE

Problem with RESTORE


I have received a SQL backup of some data from a client and am trying to restore it to my SQL Server.

I am getting Error 3270 - Internal Consistency and 3013.

I have the following files:
stonav04NavisionData.bak (22GB)
stonav04NavisionLog1.bak (344kb)
stonav04NavisionLog2.bak (344kb)
master.bak (15MB)

Using the Filelist option on the biggest file I get
Navision_Data    e:\MSSQL\data\Navision_Data.mdf
Navision_1_Data    e:\MSSQL\data\Navision_1_Data.ndf
Navision_2_Data    f:\MSSQL\data\Navision_2_Data.ndf
Navision_3_Data    g:\MSSQL\data\Navision_3_Data.ndf
Navision_4_Data    h:\MSSQL\data\Navision_4_Data.ndf
Navision_Log    l:\MSSQL\data\Navision_Log.ldf

(If you need the full list of fields, let me know and I will post it)

    FROM DISK = 'E:\SQLData\Equant\EquantDataNavision\stonav04NavisionData.bak'
    MOVE 'Navision_Data' TO 'E:\SQLData\xx\Navision_Data.mdf',
    MOVE 'Navision_1_Data' TO 'E:\SQLData\xx\Navision_1_Data.ndf',
    MOVE 'Navision_2_Data' TO 'E:\SQLData\xx\Navision_2_Data.ndf',
    MOVE 'Navision_3_Data' TO 'E:\SQLData\xx\Navision_3_Data.ndf',
    MOVE 'Navision_4_Data' TO 'E:\SQLData\xx\Navision_4_Data.ndf',
    MOVE 'Navision_Log' TO 'E:\SQLData\xx\Nsvision_Log.ldf'

I then get

Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

I haven't done anything with the smaller files - do I need to include those as well?

I am assume I am right to leave the Master backup alone?

Thanks in advance


RE: Problem with RESTORE

First, you need to contact the person who sent you the files and make sure the Master.bak is indeed a backup of the Master db and not an arbitrarily picked name for a backup of the same DB you're trying to restore.  SQL allows you to name your backup device anything you want with the exception of certain character usage, so it is entirely possible someone just decided to name a backup file "master" without it having anything to do with the actually Master DB.

Second, you need to find out if you're trying to restore a striped backup set.  Ask the user what order (if any) the backups were done in.  Ask if these are filegroup/file backups or a striped backup or if each backup is an individual complete backup.

If filegroup/file backups, you'll need to follow the restore procedures for those types of backups.  If striped backup, your best bet is to process them through EM since I know in EM you can restore from multiple devices at the same time (which is required for striped backups).  

Let us know if you need any more info after you get those questions answered by your user.

Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close