We have a log shipping pair that has the secondary server in a read only
state. My question is how to I get that server into a useable state if there
are no available transaction logs to restore with recovery?
For example the primary server becomes unavailable and all of the logs that
were shipped to the secondary server have already been restored.
Have a look at sp_change_secondary_role. This is the correct way to do it,
although restoring with recovery would also do the trick.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment