var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Log shipping recover
I have changed the roles of primary and secondary servers due to server failure.
Can anyone advise how to revert back to previous main server? Are these any links available?
See BOL topic:
How to set up and perform a log shipping role change (Transact-SQL)
In couple words - you have to set up log shipping again (move last backup from secondary to primary with stopping any activity of course on first one).
If I set up log shipping with the old server, it becomes secondary. But I want to make my old server primary again.
Would I need to copy the db from current primary to old primary server, switch off the current server and switch on the old one?