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.youtube.com/watch?v=7zlCBhvFkhM which looks simple to follow. Would you guys recommend I do like he says? Any significant risk involved?

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.

6 Replies

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)

Forum Discussion

Bacis SQL Maintenance Plan

6 Replies

Resources