I had a question on Log shipping Manual Fail over
Let me explain about environment, Primary Server A (with Cluster setup A-P Mode) Secondary server B(DR server standalone).
We had enabled Log Shipping on a database TEST from Primary Server and now we would like to test by doing a manual fail over and i had few questions.
Log Shipping Jobs are disabled on both A and B Servers and Log shipping is not disabled or removed, Once the Server B is brought online by restoring the all the logs from Server A
- Can i re-attach/reconfigure the secondary database to existing Log shipping once it is online.
- I tried using backup with no recovery option on secondary database and log shipping restore jobs are skipping.
- Is there any method expect role changing can we reconfigure the log-shipping without restoring the database from first?
any references would be appreciated.