|
Back
Methods for Setting Up Backups in SQL Server
You can run backups manually, but the best approach is to schedule backups using SQL Agent.
Once you set up the backup job, let SQL Agent run the backups on a set schedule. This can be done one of three ways:
Enterprise Manager
- Right click on the database name.
- Select "All Tasks."
- Select "Backup Database."
Once the options are set, you can then use the schedule option to create a job.
T-SQL
- Using BACKUP commands, you can create the command and then use Enterprise Manager to create a job or use T-SQL to create the job.
- You have the ability to create Database, Differential and Transaction backups using T-SQL.
Maintenance plans
- SQL Server has a maintenance plan wizard that walks you through whether you want to do Database and/or Transaction backups. The wizard also allows you to set the backup schedule.
- To access the wizard in Enterprise Manager, under Management right click Database Maintenance Plans and select New Maintenance Plan.
- Differential backups are not an available.
- The default for transaction log backups is once a day, which you should change to more frequent transaction backups.
Back
|
|