Forum Discussion

Copper Contributor

Nov 02, 2023

Solved

Bacis SQL Maintenance Plan

I am not officially a DBA, but found myself having to manage an SQL server. And the server is in the cloud, and its backup is taken care of by the cloud service provider. I've found https://www.y...

Seaoar
Nov 09, 2023
Last night, I tried the plan in the video on an old server, and it looks like it's worked fine. And having watched the video again to do that, I noticed him mention he has another video about Ola Halengren's considering that GUI is easier.

So I decided to go with the GUI for now, and find time later to learn about Ola Halengren's.

olafhelper

Bronze Contributor

Nov 03, 2023

I am not going to watch the whole video to guess at the end, what you may want.
Please describe which kind of maintenance you are looking for.

Seaoar

Copper Contributor

Nov 06, 2023

I'm looking for a standard way to keep my DBs in good shape. You can say a best practice.

olafhelper
Bronze Contributor
Nov 06, 2023
Seaoar , then better use Ola Halengren's scripts
SQL Server Backup, Integrity Check, Index and Statistics Maintenance (hallengren.com)
- Seaoar
  Copper Contributor
  Nov 07, 2023
  I appreciate you've given me this suggestion. And I am not very comfortable with scripts and prefer a GUI method.
  - olafhelper
    Bronze Contributor
    Nov 07, 2023
    You only have to run the script, it creates everything incl. SQL Server-Agents jobs for scheduling.
    And you can edit the jobs using SSMS GUI.