How to restore a log? Now we get an error

[Rene]

Hi,

While restoring the log we receive a message after about 30 minutes:

Processed 1152109 pages for database 'restest', file 'sales_Log' on
file 1
Server: Msg 9004, Leverl 21, State 20, Line 3
An error occurred while processing the log for database ' '.

It is unclear why the databasename is an empty string, I guess there must be
something corrupt hereo or a bug.

These are the steps we followed:
- restore database with norecovery (to different database)
- restore the log with recovery

The database stays un-accessable after the restore log, so it seems there
was no recovery done.
When I look at the files I see a restest_Log with about the same size
of the log we try to restore. It is unclear if the restore database
put this file here, or it is created during the restore log.

Someone has a clue?

Regards,

Rene

[Rene]

Not exactly, first of all we are running SQL2000, secondly the message is:
An error occurred while processing the log for database ' '.

There is *no name* of the database. If is was correct it would say:
An error occurred while processing the log for database 'Sales'.

So or some execption occured which resulted in a bug, or the message with no
databaseanme is a standard message from SQL (I won't believe this).

The database was restored with no recovery (and is not accesible), it seems
the log was restored too.

I tried a in time restore, but it takes 30 minutes too before the message
shows up.

Rene
"Dejan Sarka" <de************************************@avtenta.si > schreef in
bericht news:uN**************@TK2MSFTNGP12.phx.gbl...

Maybe the article at
http://support.microsoft.com/default...b;en-us;277843 can help you?
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rene" <[e-mail]> wrote in message
news:vi************@corp.supernews.com...

Hi,

While restoring the log we receive a message after about 30 minutes:

Processed 1152109 pages for database 'restest', file 'sales_Log' on
file 1
Server: Msg 9004, Leverl 21, State 20, Line 3
An error occurred while processing the log for database ' '.

It is unclear why the databasename is an empty string, I guess there must

be

something corrupt hereo or a bug.

These are the steps we followed:
- restore database with norecovery (to different database)
- restore the log with recovery

The database stays un-accessable after the restore log, so it seems

there was no recovery done.
When I look at the files I see a restest_Log with about the same size
of the log we try to restore. It is unclear if the restore database
put this file here, or it is created during the restore log.

Someone has a clue?

Regards,

Rene