CODEWITHSUNDEEP
sql-serverbackupssmsmaintenance-plan
erap129
erap129

Reputation: 960

Changing maintenance plan in SQL Server Management Studio

I have a maintenance plan that is set up to back up all of my 5 DB's every day. I do not need to backup them all, only part of them. I don't want to create a new job as my website is old and I don't want to make significant changes (moreover, I am not very familiar with SQL). I want to change the properties of this job to backup only certain DB's and didn't find my answer in google.

I added a screenshot of the task I want to modify. If any additional info is required in order to help me please tell me so.

enter image description here

Thanks in advance.

Upvotes: 3

Views: 5311

Answers (1)

BytesOfMetal
BytesOfMetal

Reputation: 724

Despite the off-topic and sorry if I shouldn't answer: Right click on the "Back Up Database Task" node --> Edit --> General Tab You could find there a list of databases so you can check/uncheck them

Upvotes: 1

Related Questions