| Author |
SQL 2000 Server SP2
|
|
| Stumped 2002-11-21, 9:23 am |
| 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!
| |
| Tibor Karaszi 2002-11-21, 9:23 am |
| Someone (Veritas?) did a restore WITH STANDBY. Do below to get it out of standby:
RESTORE DATABASE dbname WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Stumped" <me@me.com> wrote in message news:e2bb01c2916c$5e5ffe40$8af
82ecf@TK2MSFTNGXA03...
> 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!
>
| |
| Stumped 2002-11-21, 10:24 am |
| Hey thanks alot guys!
That worked!
I'll try to get my B/U running right now...wish me luck
and Thanks again!
Peace!
>-----Original Message-----
>Someone (Veritas?) did a restore WITH STANDBY. Do below
to get it out of standby:
>
>RESTORE DATABASE dbname WITH RECOVERY
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>
>"Stumped" <me@me.com> wrote in message
news:e2bb01c2916c$5e5ffe40$8af
82ecf@TK2MSFTNGXA03...
>> 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!
>>
>
>
>.
>
|
|
|
|