October 17, 2014 at 1:22 pm
my scenario is that i had log shipping configured between two sql servers and because of an issue the restore stopped few days back.
Since the retention period has already expired and the purge job has already deleted the logs from the primary server I cannot patch the logs to dr to synch it with the primary server.
My question is how can I backup tlogs from the primary sql server for a specific duration. For example from the time of failure lets call it (15 October) till the current time (17 october 10 pm) manually .
I dont want to take a differential backup or a full backup and restore it to the secondary server as that would require me to delete the log shipping configuration and re do it .
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply