Scheduling Backups Using the SQL Maintenance Plan Wizard
Until now you have performed our backups through a Query Window in SQL Server Management Studio. Of course, in production systems, backups need to be scheduled to run automatically, without any user input. This can be done using any scheduling software. SQL Server has a built-in scheduler as part of the SQL Server Agent Service. With SQL Server Agent Jobs, it is possible to define T-SQL batches to run on given schedules. This feature provides the functionality you need to automate your recovery strategy.
Have a look at another easy way to schedule backups by using a wizard. The SQL Maintenance Plan Wizard is a tool that helps perform standard tasks, like Backup, Index Defragmentation, ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
