How to take Backup of BackUp DB in SQL Server 2012 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.


Background:

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.

Question:


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?
Changing the IP of the secondary server shouldn't be an issue as long as you used DNS names in the log shipping configuration.

To answer your questions:


No you can't take a backup of a standby database, at least not with the native functionality in SQL Server.
As long as all the setting stay the same, there shouldn't be any impact. You can disable the copy and restore job before the change though.
There shouldn't be any impact as long as you used DNS names in your log shipping configuration. The only thing that I can think of is that you need to refresh the DNS cache of the primary server to get the new IP address.