Automating SQL Server Administration Tasks
In this post I would like to demonstrate with hands-on examples how to use automation (jobs,alerts,operators,notifications) in SQL Server to automate SQL Server administration tasks.
The importance of automating tasks is profound.The following tasks could be automated
- Backing up the database
- Checking data integrity
- Dropping and re-creating indexes
- Transferring data
(read more)