September 18, 2018 at 11:21 am
Ok, I have to ask a stupid question since I can't find it otherwise. The two database that SSRS uses, are they considered a "system" database or "user" database when selecting databases in the maintenance plans?
September 18, 2018 at 11:45 am
They are user databases, as far as the SQL maintenance plans are concerned.
September 18, 2018 at 11:51 am
Thank you Scott, that is exactly what I was looking for!
September 19, 2018 at 2:57 am
Hi,
what kind of maintenance plan are you creating?
There are a lot of wunderfull scripts from ola hallengren, they can do a lot more then the maintenance plans.
Kind regards,
Andreas
September 19, 2018 at 10:33 am
I was only looking to see how the maintenance plan categorized those two databases. I have separate plans for system vs user databases and just needed to know which one affected those two dbs.
I do know about his scripts. I used to use them for doing index and statistics updates but 2016 added all of that in so I’m just using the tools built in.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy