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

 

[SQLBill]

How did you make your differential backups? Can you supply the code?

-SQLBill

Posting advice: FAQ481-4875

 

[phil22046]

I restore the full backup, attempted a differential install and couldn't, so I tried the earliest T-log restore after the Full, and that did restore.

It seems that my differential backups are useless, so I have stopped doing those.

Right now I do a Full backup at 12:30 am every day and do T-log backups every 1/2 hour starting at 6:00am and continueing until 11:00pm

 

[SQLBill]

That will work. Just remember that if something happens, do an immediate log backup if you can. Otherwise, you can only restore upto what was on the last log backup you did.

BTW-you did use WITH DIFFERENTIAL didn't you?

Examples
This example creates a full and a differential database backup for the MyNwind database.

-- Create a full database backup first.
BACKUP DATABASE MyNwind
TO MyNwind_1
WITH INIT
GO
-- Time elapses.
-- Create a differential database backup, appending the backup
-- to the backup device containing the database backup.
BACKUP DATABASE MyNwind
TO MyNwind_1
WITH DIFFERENTIAL
GO

-SQLBill

Posting advice: FAQ481-4875

 

[phil22046]

I did use the Differential clause when I was doing the Differential backups. But I am not doing that now.