| Bruce de Freitas 2002-11-21, 9:23 am |
| Hey Stmpy. not sure why it got in that mode, maybe
someone was doing log shipping to it?? or the database
was restored in stanby mode??
But, look up the RESTORE command's WITH RECOVERY option
and the section on Using Standby Servers...
RESTORE DATABASE MyNwind
WITH RECOVERY
Bruce
>-----Original Message-----
>Why am I unable to change read only setting on several
>DB's? I get an error 5063: Database 'DBname' is in warm
>standby. A warm-standby database is read-only.
>ALTER DATABASE statement failed.
>sp_dboption failed.
>How do I get the database out of "warm standby"?
>And what caused this?
>This is a new database/databases and I have not been able
>to get the back up running using Veritas BE. There has
not
>been any attempt to restore these DB's so I have no idea
>why they would be locked as read-only. Please help!
>See the attached file...it is a screen shot of my
problem.
>When I uncheck the read-only box and hit ok I get this
>error 5063!
>
|