Monday, March 19, 2012

Applying SP to Log-shipping Standby server

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