New SQL Server 2005 Video Tutorial: SQL DBA 101: How to Quickly Schedule a Backup Job

SQL DBA 101: How to Quickly Schedule a Backup Job - view details

This video is a user request from Ross who asked us to, 'A step-by-step document (or video) outlining the steps required to setup a backup routine (using the built-in management tools) that will backup the entire database, every 12 hours, overwriting the previous backup. Also, if possible, additional comments that explain how "not" to overwrite the previous backups.'

Okay - easy enough! This video is the quickest route to that purpose so, if you want to see how to quickly do backups, this video is for you.

Highlights from this video:

• How to understand the "Backup Database" pane in SSMS
  
• Editing T-SQL backup scripts and understanding the options available
  
• How to create a SQL job
  
• How to create a T-SQL based SQL job
  
• How to Schedule a SQL Job
  
• How to use Maintenance Plans to implement a backup job

and much more

---

• Source: SQL Server videos
• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 200 (Beginner - Intermediate)
• Length: 6:45 (7.05MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: database administration, shared schedules, jobs