|  |
| Author |
I am unable to change read only setting on DB
|
Duhhhh... the Newbie
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 I am unable to change read only setting on DB
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?
Report this post to a moderator
|
|
 11-20-02 10:23 PM
|
|
James Hunter Ross
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: I am unable to change read only setting on DB
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?
>
Report this post to a moderator
|
|
|
11-20-02 10:23 PM
|
|
Newbie
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: I am unable to change read only setting on DB
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?
>>
>
>
>.
>
Report this post to a moderator
|
|
|
11-20-02 11:23 PM
|
|
Keith Kratochvil
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: I am unable to change read only setting on DB
> 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?
>
Report this post to a moderator
|
|
|
11-20-02 11:23 PM
|
|
|
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
