In Our environment, Log log shipping is configured and working good.
- Transaction logs are Backed-up on Primary Server.
- Copy to Backup DB
- Restore on Backup DB.
We are in process of changing the IP of Backup (Secondary) DB server. And before changing IP, client wants to take the backup of the Secondary(Backup) DB.
Is it possible to take the backup of Secondary Database? (When I Right click on Backup (Secondary) DB --> Task --> backup, backup option is grayed out.)
--> Do I need to 'Take Offline' to take back up?
--> Or is there any other way?
Will there be any impact if we change IP of Backup (Secondary) DB and do we need to make changes anywhere else?
Will Log shipping keeps running without any issues, or do we need to reconfigure it as new?