Logshipping backup job deleting the old files

Question

Post reply

Logshipping backup job deleting the old files

bindview

Right there with Babe

Points: 772
More actions
September 13, 2011 at 12:53 pm

#257340

We have a logshipping setup (sql server 2005) where the backup setting is configured to delete the transactional log files older than 3 days. In my situation when the backup job run it deletes all the older files in the backup path and creates a new backup files.
Log shipping is running successfully but I want to keep all transactional log files for atleast 3 days
Any idea why the files are being deleted?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

Please execute the following against your primary server and post the results

exec sp_help_log_shipping_primary_database @database = 'YourLogShippedPrimaryDatabase'

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

bindview Right there with Babe Points: 772 More actions · Answer 2

Results:

Primary_id - XXXXXX

primary_database - ABC

backup_directory - Networkpath

backup_share - Networkpath

backup_retention_period - 4320

backup_threshold -60

threshold_alert -14420

threshold_alert_enabled -1

history_retention_period - 5760

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

bindview (9/15/2011)
Results:
Primary_id - XXXXXX
primary_database - ABC
backup_directory - Networkpath
backup_share - Networkpath
backup_retention_period - 4320
backup_threshold -60
threshold_alert -14420
threshold_alert_enabled -1
history_retention_period - 5760

backup_retention_period - 4320 -- what units are these ?

Thank You,

Best Regards,

SQLBuddy

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

sqlbuddy123 (9/16/2011)
backup_retention_period - 4320 -- what units are these ?

The length of time in minutes.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

Right.. I was thinking in terms of GUI .. Not the SP.

Thank You,

Best Regards,

SQLBuddy

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

bindview (9/15/2011)
Results:
Primary_id - XXXXXX
primary_database - ABC
backup_directory - Networkpath
backup_share - Networkpath
backup_retention_period - 4320
backup_threshold -60
threshold_alert -14420
threshold_alert_enabled -1
history_retention_period - 5760

That's equal to 3 days .. Bit Weird ...

Do you know any other delete process running on that folder and cleaning up the things ..

Or try to pause the LS and create another sub folder with that Backup Folder and use that subfolder as the LS backup folder and now no other process should see this new change ...

Also what is the Service Pack and Edition of your SQL Server ?

Thank You,

Best Regards,

SQLBuddy

bindview Right there with Babe Points: 772 More actions · Answer 7

The edition is sql server 2005 sp4. I will try your solution of creating the new backup folder and will post the results soon.

Thanks for the help.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

bindview (9/18/2011)
The edition is sql server 2005 sp4. I will try your solution of creating the new backup folder and will post the results soon.
Thanks for the help.

The network path you are backing up to is this a local folder on the primary server, a folder on the secondary server or a location on a fileserver?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉