MS SQL Server - Sql2k db recover

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Sql2k db recover

mecn

2006-03-05, 8:24 pm

Hi,

I have log shipping standby server.
The db is read-only standby mode. There is anyway that i could recover that
db without the log file.

Thanks

Tibor Karaszi

2006-03-05, 8:24 pm

Just do:

RESTORE DATABASE dbname WITH RECOVERY

No backup file is needed. But you won't be able to ship any more backups to this after the recovery.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"mecn" <mecn2002@yahoo.com> wrote in message news:e9mB1OtPGHA.1580@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I have log shipping standby server.
> The db is read-only standby mode. There is anyway that i could recover that db without the log
> file.
>
> Thanks
>

Sponsored Links