title: Microsoft SQL Server Management Studio Maintenance Plan doesn't proceed past first step
body: <p>We've been struggling the whole day to get a Maintenance Plan to work on our MS SQL Server.
  Problem is: Whatever we do, when the Plan gets started (either manually, directly, or via the SQL Server Agent Job which got created automatically when we started the plan), only the initial step will be performed. After that 1st step the Maintenance Plan ends and reports success.
  Originally we've planned to do the following steps in this order:</p>
  <ul>
  <li>Check Database Integrity (in case of error, repair DB)</li>
  <li>Backup Database</li>
  <li>Backup Transaction Log</li>
  <li>Shrink Database
  -- in case of errors, notify Operator</li>
  </ul>
  <p>In this order, the Database Check will be performed and the Plan reports success.
  We then changed the order - put the check at the end and start with the DB Backup.
  In that order, the DB Backup will be performed and the Plan reports success.
  This is where we took a screenshot of our attempts:
  <a href="https://i.stack.imgur.com/myJEK.jpg" rel="nofollow noreferrer">Maintenance Plan Screenshot</a></p>
  <p>Then we tried to change all &quot;Success&quot; constraints to &quot;Completion&quot; - again to no avail.
  Running out of options, I took the liberty to ask the experts here, hoping that someone succeeded in this challenge already.</p>
  <p>Thanks in advance!</p>