Scenario: SQL2000 server that is the Standby server in a log-shipping scenario
The need: Apply SP4 to the standby server
Issue: Service pack installation wants all databases to be "writable". The databases on the standby server are "IsInStandby" state and cannot be made "writable" (non-Read-Only) by the Alter Database command.
Question: is there a way to alter the state so that I can apply the service pack without removing log-shiping, applying the sp and then reestablishing log-shipping?
ReadmeSql2k32sp4.htm:
http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32sp4.htm#_1462462_considerations_for_an_instance_i_gq59
No comments:
Post a Comment