| Author |
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
Matt
| |
| Tibor Karaszi 2006-02-10, 8:23 pm |
| 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
>
>
| |
|
|
| Tibor Karaszi 2006-02-11, 3:23 am |
| 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@hotmai
l.nomail.com> wrote in message
> news:u%23xlbknLGHA.3936@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|