title: Restart log shipping when out of sync
body: <p>The scenario is. A database secondary server are for different reason out of sync or is suspected that is not sync.  Someone has made the secondary databases online by mistake or other mishaps. If you now want to make sure that they are set back on track. How do you do that? Preferably swiftly and for many databases at once.</p>
  
  <p>When you set up a log shipping between two servers using the guide it takes care of the initial backup and copying of backup file and then the initial restore.
  If I have to redo that I have to unable/enble and redo the  loghipping and fill all the parameters again. Is there an other way? Can I use <a href="http://msdn.microsoft.com/en-us/library/bb283327.aspx" rel="nofollow">sqllogship application?</a>
  I there a "<code>C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe</code>" -Restart -server SQLServ\PROD2
  Or is there something that could be done easily with powershell and <a href="http://msdn.microsoft.com/en-us/library/dd938892%28v=sql.100%29.aspx" rel="nofollow">SQL Server Management Objects - SMO?</a></p>
  
  <p>I want to use all the parameters that are already in tables like <code>log_shipping_secondary</code>.</p>
  
  <p>I have not found any scripts for doing this. I looked at the generated script when I used the guide but that does not contain the inital backup and copy. I can write my own script. I am just afraid someone will say: Why did you not just run: $smoLogShipping.Redo</p>