#Schedule server 2003 backup batch file manual#
What Does Automating a Database Maintenance Task Mean?Īutomating a database maintenance task means scheduling a database maintenance task to run automatically without any manual intervention. How is a Database Maintenance Task done?Ī database maintenance task is normally performed manually by a database administrator from time to time, or it can also be scheduled to run automatically. Typically, professionals responsible for database system maintenance, such as database administrators, perform database maintenance tasks, however, this may change under certain circumstances. What is a Database Maintenance Task?Ī database maintenance task, as the name indicates, is a task which assists in managing or maintaining a database to ensure its smooth operation.įor example, creating database backups on daily basis is a database maintenance task which ensures that the database is backed up, so that in case of any incident, which ends up either corrupting the database or making it unstable, it can be restored successfully without losing any data.
![schedule server 2003 backup batch file schedule server 2003 backup batch file](https://www.data-protector.org/wordpress/wp-content/uploads/2016/05/EADR_01.png)
Let us go through some basic concepts for automating SQL database maintenance tasks with the SQLCMD utility. The SQLCMD utility can be a real time saver for database developers and DBAs since they can immediately run the necessary SQL scripts from the command line, and automating database maintenance tasks with the SQLCMD utility is a plus. Typically, automating database tasks requires SSMS (SQL Server Management Studio) for scheduling jobs that run these tasks, but in this article, an alternative approach is used to automate database tasks without having to use the much-needed SSMS.
![schedule server 2003 backup batch file schedule server 2003 backup batch file](https://www.farukterzioglu.net/wp-content/uploads/2017/09/taskscheduler-285x300.jpg)
This article is about automating SQL database maintenance tasks through SQLCMD utility which lets you run T-SQL commands directly from the command prompt without using SSMS (SQL Server Management Studio).