Hi @shaikh shoaib ,
Yes, you can do that follow below steps.
- Remove a Secondary Database a. On the primary server, execute sp_delete_log_shipping_primary_secondary to delete the information about the secondary database from the primary server. b. On the secondary server, execute sp_delete_log_shipping_secondary_database to delete the secondary database. c. On the secondary server, disable the copy and restore jobs. For more information, see Disable or Enable a Job.
2.Disable the log shipping jobs on primary server.
3.Back up the database on primary server.
4.Restore the database with the backup you just created and with no recovery on secondary server.
5.Re-enable the log shipping jobs on both servers.
Refer to the MS document Remove a Secondary Database from a Log Shipping Configuration (SQL Server).
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.