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...
> > 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 !
>
>|||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...
> 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...
> > > 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 !
> >
> >
> >|||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...
> > 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...
> > > > 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
Look at this article
http://www.karaszi.com/sqlserver/info_corrupt_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
> 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...
> > > 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...
> > > > > 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 !
> > > >
> > > >
> > > >
> >
> >
> >