May 9, 2008 at 4:13 am
I have to apply sp3a on a standby server. I got warning that "Setup has detected one or more databases which are not writable". When I issued the command to alter database as READ_WRITE I got error
Server: Msg 5063, Level 16, State 1, Line 1
Database 'SUNDB' is in warm standby. A warm-standby database is read-only.
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
What should I do? How can I apply sp3a?
June 2, 2008 at 12:48 pm
Change the status of your database, SUNDB, then re-apply your service pack.
June 3, 2008 at 9:54 pm
By status you mean READ_WRITE?? I tried alter database command but failed.
June 4, 2008 at 9:38 am
Did you try the command,
RESTORE DATABASE yourDB WITH RECOVERY
?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply