New SQL Server Video Tutorial: Part 2- Writing the Stored Procedu re to Backup a Database: Part A

Part 2- Writing the Stored Procedure to Backup a Database: Part A - view details

In this second video in the series, we will continue piecemealing our previous coding to create a stored procedure to backup a database. Scott will cover the database name, the backup folder, and the backup extension.

Highlights from this video:

• Review of Input Output parameters
• Working with unclosed quotation marks and apostrophes
• Stringing Dynamic SQL
• Using CONVERT syntax to generate a file name from the date
• The problem with the default of appending backup files
  • How to overwrite existing backup files

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 200 (Beginner - Intermediate)
• Length: 12:30 (0.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

---

Keywords Associated with this video: stored procedure, database, backup, automate, automation,file