Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 716
erap129 Avatar asked Sep 16 '26 08:09

erap129


1 Answers

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

like image 174
Petaflop Avatar answered Sep 17 '26 21:09

Petaflop



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!