Restore Problem

Hi,
I need to restore a database to 10:06 this morning. I restored the last full
backup, then the 10:00 transaction log backup, the 11:00, and specified that
the point in time I want to recover to is 10:06. When I do this, the restore
seems to work, but the database and its name go white and a (loading) label
appears beside it. When I attempt to click on the databases properties I get
the following message, "Error 927. Database cannot be opened. Its in the
middle of a restore". I have left the database 30 minutes, but this is
message still appears. It cannot still be processing transactions as not many
took place.
This message only appears when I'm doing a point in time restore. If a
restore the last full database and then the transaction logs, everything is
ok. I have also restricted the database while I am doing the restore.
Any help would be appreciated.
Michael
Try running RESTORE DATABASE foo WITH RECOVERY
(replace foo with the name of your database).
Keith
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:21B1B8FB-A9FE-48E9-9327-8C4430FCA4DB@.microsoft.com...
> Hi,
> I need to restore a database to 10:06 this morning. I restored the last
full
> backup, then the 10:00 transaction log backup, the 11:00, and specified
that
> the point in time I want to recover to is 10:06. When I do this, the
restore
> seems to work, but the database and its name go white and a (loading)
label
> appears beside it. When I attempt to click on the databases properties I
get
> the following message, "Error 927. Database cannot be opened. Its in the
> middle of a restore". I have left the database 30 minutes, but this is
> message still appears. It cannot still be processing transactions as not
many
> took place.
> This message only appears when I'm doing a point in time restore. If a
> restore the last full database and then the transaction logs, everything
is
> ok. I have also restricted the database while I am doing the restore.
> Any help would be appreciated.
> Michael
>
|||Hi Keith,
I am using Enterprise Manger not Query Analyser but I have left the database
operational after the restore and I am still having this problem. Any other
ideas ?
Michael
"Keith Kratochvil" wrote:

> Try running RESTORE DATABASE foo WITH RECOVERY
> (replace foo with the name of your database).
> --
> Keith
>
> "Michael" <Michael@.discussions.microsoft.com> wrote in message
> news:21B1B8FB-A9FE-48E9-9327-8C4430FCA4DB@.microsoft.com...
> full
> that
> restore
> label
> get
> many
> is
>
|||Please try running the script via Query Analyzer.
Keith
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:78F64D30-E5BC-4D39-99A9-E939B84DD9D5@.microsoft.com...
> Hi Keith,
> I am using Enterprise Manger not Query Analyser but I have left the
database
> operational after the restore and I am still having this problem. Any
other[vbcol=seagreen]
> ideas ?
> Michael
> "Keith Kratochvil" wrote:
last[vbcol=seagreen]
specified[vbcol=seagreen]
I[vbcol=seagreen]
the[vbcol=seagreen]
not[vbcol=seagreen]
everything[vbcol=seagreen]
|||You have to go to the Options Tab on the RESTORE wizard in EM and specifiy
if you want to leave the database operational or nonoperational. For your
database and first log restore, you'd have to leave the database
"nonoperational and able to restore addional backups". The last log file
restore with the 10:06 stop time will have to be left Operational.
(..I have to admit that I've never done this from EM so there might be other
issues related to it...).
Regards
Steen
Michael wrote:[vbcol=seagreen]
> Hi Keith,
> I am using Enterprise Manger not Query Analyser but I have left the
> database operational after the restore and I am still having this
> problem. Any other ideas ?
> Michael
> "Keith Kratochvil" wrote: