Home / server / Questions / 456451
Accepted
Howard Pinsley
Asked: 2012-12-09 18:12:59 +0800 CST

How do I change the number of days a copied transaction log is kept in a log shipping configuration?

  • 772

I think this is a pretty simple and perhaps stupid question. I've established log shipping between two SQL Server 2008 servers using the GUI (i.e. the SQL Server Management Studio). It's been running fine -- but now I want to change the number of days the copied files are retained on the secondary server. Is it simply a matter of going back to the GUI and change it there. Is it smart enough just to make that simple change or is the GUI only used to create the initial log shipping configuration?

sql-server-2008

1 Answers

  1. Best Answer

    Yes, you can change this through the GUI.

    Connect to the Primary Server using SSMS, right-click your database, and pick properties. On the 'Select a page' pane, pick Transaction Log Shipping.

    In the section for Secondary database, you should see your Secondary Server listed. Click the three ellipses to go to the Secondary Database Settings page.

    enter image description here

    There you should see a section labeled: Delete copied files after

    enter image description here

    Make your necessary adjustments there, and you're all set.

    • 1