Friday, March 9, 2012

Error 5063: database .. is in warm standby. A warm-standby is read only.

A freshly restored DB is readonly(I choose "readonly" ,when restore it).
The restore was successful ,but when try to change it to readwrite .
Error 5063 poped up.
I found on information in support KB ,please help..
Thanks!!.
You could try this:
USE MASTER
GO
RESTORE DATABASE <database name> WITH RECOVERY
GO
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Straight" <someone@.> wrote in message
news:ug4xtUMLEHA.2736@.TK2MSFTNGP11.phx.gbl...
>A freshly restored DB is readonly(I choose "readonly" ,when restore it).
> The restore was successful ,but when try to change it to readwrite .
> Error 5063 poped up.
> I found on information in support KB ,please help..
> Thanks!!.
>

No comments:

Post a Comment