Cancelling Log Restore while still restoring

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven Kong - 09 Mar 2008 00:23 GMT

What happens if I cancel out in the middle of a log restore? Would I have
to restore from a full backup in order to recover the database? I'm just
asking because it appears to be hanging at 30 Percent. Is there a way to
check if it's still doing anything. Sp_who shows that it's still runnable.

Thanks

Reply to this Message

Kalen Delaney - 09 Mar 2008 00:35 GMT

Hi Steven

Please always tell us what version you are using.

Since I'm not sure if you're on SQL 2005, you can just look at the
master..sysprocesses table and see if the values for cpu and physical _io
are changing. That table should also tell you if it's blocked or waiting for
some reason, so look at the columns indicating waittype, waittime, etc.

Signature

HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com

> What happens if I cancel out in the middle of a log restore? Would I have
> to restore from a full backup in order to recover the database? I'm just
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Steven Kong - 09 Mar 2008 01:10 GMT

Thanks So much. I will look at that. I'm using SQL 2000 SP4, by the way

> Hi Steven
>
[quoted text clipped - 13 lines]
>>
>> Thanks

Reply to this Message