Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 am running into a problem while trying to save a transaction log database backup maintenance task:

  1. Add the 'Back Up Database Task' to the maintenance plan.
  2. Edit the task.
  3. Select backup type: 'Transaction Log'.
  4. Select any database running with Full Recovery Model.
  5. Close the task.
  6. Re-open the task. Notice that the database I selected is not checked anymore.

I can select all databases, all user databases, specific databases...none of them ever save. Every time I re-open the task that field is switched back to < Select one or more > option.

I've connected as user sa and I've connected with Windows Authentication. Same result. Also, I've double-checked that the databases I'm trying to backup are in Full recovery model.

I'm running SQL Server 2005 SP2 on Windows 2003 R2 SP2.

enter image description here

share|improve this question
And if you run the maintenance plan backup after selecting that database, does it get backed up? – HopelessN00b Mar 25 '13 at 19:02
I hope this doesn't sound off, but you are actually clicking Save between steps 4 and 5 right? – squillman Mar 25 '13 at 19:14
@HopelessN00b: It does oddly enough. squillman: I definitely am. :) – zippy Mar 25 '13 at 21:42
Well, I checked on our Server 2003/SQL 2005 server and didn't get the same results as you, like I thought I would... so I don't know what's going on. – HopelessN00b Mar 26 '13 at 12:04
I'd say you should apply the latest service pack to the machine running SSMS, since it sounds like a client bug and you are running 2 SP behind current. – Jason Cumberland Mar 26 '13 at 21:11

Your Answer


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

Browse other questions tagged or ask your own question.