SP3a on Standby Server

  • 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?

  • Change the status of your database, SUNDB, then re-apply your service pack.

  • By status you mean READ_WRITE?? I tried alter database command but failed.

  • 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