How to perform SQL Server maintenance

sbf maintenance

SQL Server maintenance is just as important as creating backups of your databases.
Without a doubt there are a lot of organizations that install a SQL Server database or more without setting their maintenance plans up first 
Things generally go smoothly and at the beginning there is no problem, that is, until a problem appears.

SQL Server maintenance

It’s very rare that a database server completely fails, most of the times when an issue occurs you can notice a drop in terms of performance as the server runs out of disk space or operations are very slow to perform, before the database becomes corrupt.

This kind of scenario shows proof as to why it’s important that besides backup plans for your database, you have set up maintenance plans.

Usually you will have a simple operation/task that you want to run as part of your maintenance or backup plan. Most of these simple and general tasks are already available in SQL Server and can be set up through the available Maintenance Plan options.

But most of the times you are not the creator of the maintenance plan and you have just recently joined the DBA team at your organization and have to continue with their plan.

If their plan involves running a custom written SQL scripts or Windows batch scripts, there’s good news as these scripts can be run directly from SQLBackupAndFTP before and/or after, depending on how your plan is set up, the backup process is executed.

So, to add custom scripts to your backup job, open SQLBackupAndFTP and go to the “Custom scripts” sectionSQLBackupAndFTP Custom scripts

Here you can choose what scripts do you want to run. Will it be a  SQL (T-SQL) before or after the backup

SQLBackupAndFTP Custom scripts SQL

or you prefer to run Windows batch scripts before or after the backup.

SQLBackupAndFTP Custom scripts Windows batch scripts

[Total: 1    Average: 5/5]

About Radu Gheorghiu

Passionate SQL Developer on the journey of trying to become an expert in all things Data (storage, manipulation, gathering etc.) Information is power, and information can only be obtained from data. Thus, in order to harness the power of information, you must be a master of Data.

Leave a Reply

Your email address will not be published.