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 trying to modify and existing sql server 2005 maintenance plan. It's currently set to run a full backup that will expire in 3 days. It is also set to append existing under if files exists. I want to set it to overwrite if files exist however that particular dropdown is greyed out. I have full rights to the system and to SQL server. How can I get it to let me choose overwrite? In creating a new job the very second I tell it to create a backup file for every database it greys out the option on if files exists.

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

The closest I can come to duplicating your situation shows that when I select All Databases it switches the target backup file from Back up databases across one or more files over to Create a backup file for every database, at which point the If backup files exist options becomes irrelevant because SQL Agent will create unique filenames for the backup files. Check to see if that's the case for you. If so you'll have to reset it back over to backup across one or more files and choose your file again.

share|improve this answer
    
That's exactly what the issue was. No wi have to figure out how to get 1 file per backup per DB –  Jim B Jul 24 '09 at 17:23
add comment

Your Answer

 
discard

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.