Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

ijrussell (IS/IT--Management) (OP)
14 Sep 05 4:05
Hi

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)

RESTORE DATABASE xxx
    FROM DISK = 'E:\SQLData\Equant\EquantDataNavision\stonav04NavisionData.bak'
    WITH RECOVERY,
    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

Ian
Catadmin (Programmer)
14 Sep 05 7:14
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???"

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