Database keeps loading - urgent !

I'm trying to restore a set of 4 different databases. 2 of them went ok but
the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
option). When I try the RECOVER option I get this message
Server: Msg 3624, Level 20, State 1, Line 1
Location: filemgr.cpp:1749
Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
saflStatus)
SPID: 57
Process ID: 1604
Connection Broken
What can I do to resolve this problem ? I really need this data !Freddy
Drop the loading database and restore a new one with RECOVERY option
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> I'm trying to restore a set of 4 different databases. 2 of them went ok
but
> the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
> option). When I try the RECOVER option I get this message
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: filemgr.cpp:1749
> Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
> saflStatus)
> SPID: 57
> Process ID: 1604
> Connection Broken
> What can I do to resolve this problem ? I really need this data !|||I tried it with option RECOVER and that is when I get the error message
mentioned in my first question. Other options ?
Thanks
"Uri Dimant" wrote:

> Freddy
> Drop the loading database and restore a new one with RECOVERY option
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> but
>
>|||Hi
Is it something that someone removed the log file ?
Try detach the database and then attach it with single file option. (see
BOL)
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...[vbcol=seagreen]
> I tried it with option RECOVER and that is when I get the error message
> mentioned in my first question. Other options ?
> Thanks
> "Uri Dimant" wrote:
>
ok[vbcol=seagreen]
NORECOVERY[vbcol=seagreen]|||The log file is there. I tried to attach the file like you said and got this
error
Server: Msg 9003, Level 20, State 6, Line 1
The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
invalid.
Connection Broken
"Uri Dimant" wrote:

> Hi
> Is it something that someone removed the log file ?
> Try detach the database and then attach it with single file option. (see
> BOL)
>
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...
> ok
> NORECOVERY
>
>|||Freddy
Look at this article
http://www.karaszi.com/sqlserver/in..._suspect_db.asp
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:2C86E47A-E4B1-46CB-813B-AE6457E71EDF@.microsoft.com...
> The log file is there. I tried to attach the file like you said and got
this[vbcol=seagreen]
> error
> Server: Msg 9003, Level 20, State 6, Line 1
> The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
> invalid.
> Connection Broken
>
> "Uri Dimant" wrote:
>
message[vbcol=seagreen]
in[vbcol=seagreen]
went[vbcol=seagreen]
(FCB_DROPPED,[vbcol=seagreen]