Log Shipping question

[djj55]

Hello, SQL Server 2008R2
To continue the log shipping questions...
I would like to change the retention of log files. When we had little space we set it to 24 hr. Now we have room I would like to change the value.

Do I need to recreate the log shipping which I do using the wizard or is there a way to change a job? If so which job?

Thank you,


djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[djj55]

Found one solution.

-- On primary
select * 
from msdb..log_shipping_primary_databases

UPDATE msdb..log_shipping_primary_databases
SET backup_retention_period = 2880;

-- On secondary
select * from msdb..log_shipping_secondary

UPDATE msdb..log_shipping_secondary
SET file_retention_period = 2880

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!