we got the task to set up the DB on MS SQL Server 2014 for ARM for our customer.
What could be the best practice to configure the Maintenance Plan Task for this DB?
For what kind of tasks should we make the settings? Please see the print screen below.
Will the "ARM DataBase Maintenance" Job set these tasks automatically? What exactly does the "ARM DataBase Maintenance" job do?
Thank you very much in advance for your answer.
Thank you for your Feedback.
It will be interesting for me to see how this setting appears on the SQL Server site under Maintenance Plan Tasks. In the documentation I can find only the configuration of settings for DB.
you can't configure database settings in ARM. ARM just creates a database with the default settings which resides in the model database. If you need some database tweaking like multiple data files or multiple filegroups you have to setup it manually.
ARM does not create any maintenance jobs either. You have to setup the jobs by yourself.
At least you need a backup job. I strongly advise to use the Ola Hallengren scripts.
Easy to setup, easy to use.
The type of recovery model of the database is up to you. We use full recovery with transaction log backup.
But maybe your customer is ok with the simple mode.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.