June 13, 2012 at 10:05 am
backup job and copy job working fine. But there's a huge delay in restore job.
If the retention period is set to 12 hrs on the copied files. If there's a delay in the restore job for 13 hrs. Does the files get deleted or the process waits for the restore job to get finished.
June 13, 2012 at 3:52 pm
its the restore job that deletes the files no longer required.
---------------------------------------------------------------------
June 13, 2012 at 5:56 pm
You mean to say that..........the restore job checks the time on the file it restored and deletes the older files ???
June 14, 2012 at 4:04 am
when the restore job runs successfully files that are older than your retention period will be deleted.
If the restore is successful older files will by definition already have ben restored so are no longer required.
---------------------------------------------------------------------
June 15, 2012 at 7:18 am
deep_kkumar (6/13/2012)
backup job and copy job working fine. But there's a huge delay in restore job.If the retention period is set to 12 hrs on the copied files. If there's a delay in the restore job for 13 hrs. Does the files get deleted or the process waits for the restore job to get finished.
Retention is set on the primary server for files that the backup job takes and also on the secondary server to prune files that are copied from the primary to the secondary.
Check the column backup_retention_period in the output from sp_help_log_shipping_primary_database and also the column file_retention_period in the output from sp_help_log_shipping_secondary_database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply