Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.