Bypassing recovery for database 'mydb' because it is makred IN LOAD

Hi,
Im having a problem with a SQL server that gets an error after trying to
restore a Database. The restore says completed but it doesn't actually
complete. I have tred the Knowlege base artical 822852 with no luck still
has the same problem after going into the systemdatabases table and changing
status to 16 for the database 'mydb'.
Thanks
MattPerhaps you didn't specify WITH RECOVERY for the restore? Try:
RESTORE DATABASE dbname WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Matt" <mattbeach@.hotmail.com> wrote in message news:uWEmD3mLGHA.2624@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Im having a problem with a SQL server that gets an error after trying to
> restore a Database. The restore says completed but it doesn't actually
> complete. I have tred the Knowlege base artical 822852 with no luck still
> has the same problem after going into the systemdatabases table and changing
> status to 16 for the database 'mydb'.
> Thanks
> Matt
>|||Yes I did try however it said it restored it in 0 seconds and actually
didn't work.
Matt
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u%23xlbknLGHA.3936@.TK2MSFTNGP10.phx.gbl...
> Perhaps you didn't specify WITH RECOVERY for the restore? Try:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Matt" <mattbeach@.hotmail.com> wrote in message
> news:uWEmD3mLGHA.2624@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> Im having a problem with a SQL server that gets an error after trying to
>> restore a Database. The restore says completed but it doesn't actually
>> complete. I have tred the Knowlege base artical 822852 with no luck still
>> has the same problem after going into the systemdatabases table and
>> changing status to 16 for the database 'mydb'.
>> Thanks
>> Matt|||My guess then is that the restore wend bad and you have to redo the operation. I'd do it from Query
Analyzer (so you can save the TSQL commands used and post here if that doesn't work).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Matt" <mattbeach@.hotmail.com> wrote in message news:e3d%23z9nLGHA.1192@.TK2MSFTNGP11.phx.gbl...
> Yes I did try however it said it restored it in 0 seconds and actually didn't work.
> Matt
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:u%23xlbknLGHA.3936@.TK2MSFTNGP10.phx.gbl...
>> Perhaps you didn't specify WITH RECOVERY for the restore? Try:
>> RESTORE DATABASE dbname WITH RECOVERY
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Matt" <mattbeach@.hotmail.com> wrote in message news:uWEmD3mLGHA.2624@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> Im having a problem with a SQL server that gets an error after trying to restore a Database. The
>> restore says completed but it doesn't actually complete. I have tred the Knowlege base artical
>> 822852 with no luck still has the same problem after going into the systemdatabases table and
>> changing status to 16 for the database 'mydb'.
>> Thanks
>> Matt
>