| Author |
I am unable to change read only setting on DB
|
|
| Duhhhh... the Newbie 2002-11-20, 4:23 pm |
| 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?
| |
| James Hunter Ross 2002-11-20, 4:23 pm |
| Is the database a target of "log shipping" or part of a cluster, or
something like that?
James
"Duhhhh... the Newbie" <me@me.com> wrote in message
news:ca0101c290e0$a68763c0$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?
>
| |
| Newbie 2002-11-20, 5:23 pm |
| No...that is what I don't understand. I have 3 databases
that I am unable to back up because they got set to read
only.When I try to change this setting I get the afore
mentioned error message.
>-----Original Message-----
>Is the database a target of "log shipping" or part of a
cluster, or
>something like that?
>
>James
>
>
>"Duhhhh... the Newbie" <me@me.com> wrote in message
> news:ca0101c290e0$a68763c0$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?
>>
>
>
>.
>
| |
| Keith Kratochvil 2002-11-20, 5:23 pm |
| > How do I get the database out of "warm standby"?
RESTORE DATABASE databasename WITH RECOVERY
> And what caused this?
possibly a database RESTORE ...WITH STANDBY
--
Keith, SQL Server MVP
"Duhhhh... the Newbie" <me@me.com> wrote in message
news:ca0101c290e0$a68763c0$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?
>
|
|
|
|