Restore error message 1

[phil22046]

I created a new Database this morning for testing restores.
It is S030_B. The logical files are S030_B_Log and S030_B_data - default values.

For an hour I have been trying to restore to this database.

When I try to restore from a differential backup, I get the following error message:

Logical file 'S030_B_Log' is not part of database 'S030_B'. Use RESTORE FILELISTONLY to list the logical file names. RESTORE DATABASE is terminating abnormally

 

[ptheriault]

yup, that would do it.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[phil22046]

I got the File 1 restored ok. So next I attempted the File 3 which is the latest differential backup. I get this error:

Cannot apply the backup on device 'D:\mssql\mssql\backup\s030backup\s030diff' to database 'S030_C'.
RESTORE DATABASE is terminating abnormally

 

[ptheriault]

what state is your database in?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[SQLBill]

You probably restored the first file WITH RECOVERY. That told it that you are done doing RESTOREs.

-SQLBill

Posting advice: FAQ481-4875

 

[phil22046]

nope I didn't do that, I did it with the read only option allowing t-log restores.

 

[phil22046]

The database is listed in Enterprise Manager as S030_C(Read Only)

I get the message "Cannot apply the backup on device 'D:\mssql\mssql\backup\s030backup\s030diff' to database 'S030_C'.
RESTORE DATABASE is terminating abnormally "

Should I just start over?

 

[ptheriault]

I would. I would start right from the beginning. Take a new full backup, then a diff and then a log.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[phil22046]

OK I started over. I created database S030_D. I selected the S030Diff backup and restored File 1 to S030_D forcing it to overwrite and leaving the Database as read-only with the ablility to restore additional Transaction logs.

Now when I try and restore File 4 I get that same message.

I get the message "Cannot apply the backup on device 'D:\mssql\mssql\backup\s030backup\s030diff' to database 'S030_D'.
RESTORE DATABASE is terminating abnormally "

 

[ptheriault]

phil,
I'm at a loss as to why this isn't working for you. I restore my dev databases like this all the time.

Can you script out your restores and post it here. I'll also need to see the contents of you s030diff device.


- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[phil22046]

I wish I knew how to script out this. I am doing this through Enterprise Manager. However I could use the Sql Server 2005 dev system on my desktop to attempt this same restore.

 

[SQLBill]

Question. Did you or someone else do a Full Backup that was NOT made to that backup device?

For example:
1. Full backup made to device
2. Diff backup made to device
3. Full backup made to somewhere else
4. Transaction log backup made to device

If you restore 1 and 2, you won't be able to restore 4 as that log backup belongs to #3.

-SQLBill

Posting advice: FAQ481-4875

 

[phil22046]

Running this command in Query Analyzer

RESTORE FILELISTONLY FROM S030Diff

S030_Data J:\MSSQL\MSSQL\Data\S030_Data.mdf D PRIMARY 16238379008 35184372080640
S030_Log D:\MSSQL\MSSQL\case1_log\S030_Data.ldf L NULL 4892917760 35184372080640

 

[phil22046]

Here is what is happening:
1. Full Backup at 9:00pm every day to From Server Case1 to another Drive on Case1 which overwrites the previous backup from the day before.
2. Differential backup at 12:30am made to device S030Diff which is on server Case2
3. Transaction Log backups are made every 1/2 hour and stored on case 2 in the same directory as the S030Diff

 

[ptheriault]

phil,
Are starting with the first log file that was taken after the diff you applied? You said log file 4? But I only see two files in your restore filelist.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[phil22046]

After I created the S030Diff file as a Full Backup, I did only Differential backups to S030Diff. The transaction Log backups every 1/2 hour are to individual files and get a .TRN extension. I have not attempted and transaction log restores, only Restores on the Full backup (file 1) succeeded and the differential restore (file 4) fails.

 

[phil22046]

There are no Log files backuping up into the S030Diff device

 

[phil22046]

All the backups are being performed by the Case1 server, the restores are being performed by the Case 2 server. Could this cause any problems?

 

[phil22046]

I tried to restore the backup to the Case2 server from the case1 server. That didn't help. I get the messages:

Cannot apply the backup on device '\\sh-case2\S030backup\S030db_differential' to database S030E.
RESTORE DATABASE is terminating abnormally.

The Device name is S030diff, the phyisical file name is S030db_differential.

I am stumped.

 

[SQLBill]

Try running this:

RESTORE HEADERONLY FROM S030Diff

That should give us more information as to what is on the backup file.

-SQLBill

Posting advice: FAQ481-4875

 

[phil22046]

Here is some of the columns from the RESTORE HEADERONLY FROM S030Diff



Backup Name |Backup Type |Position | Device Type | Database Name | Database Version | Backup Size
____________|____________|_________|_____________|_______________|__________________|____________
S030 backup 1 1 102 S030 539 13406005248
S030 backup 5 2 102 S030 539 21581824
S030 backup 5 3 102 S030 539 24268800
S030 backup 5 4 102 S030 539 5722112
S030 backup 5 5 102 S030 539 2314240
S030 backup 5 6 102 S030 539 3166208
S030 backup 5 7 102 S030 539 10641408