Problem with RESTORE

[ijrussell]

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]

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???