Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

 
discard

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

Browse other questions tagged or ask your own question.