New SQL Server Video Tutorial: Part 1- Automation with Stored Procedures: Automate Backup,Restore, Copy with Stored Procedures

Part 1- Automation with Stored Procedures: Automate Backup,Restore, Copy with Stored Procedures - view details

As a database administrator, you often have to copy a database, restore a database, or backup a database. These monotonous tasks, however, can basically be done for you via automation with stored procedures by simply passing��a few��parameters. In this video series your instructor Scott will not only show you how to create these stored procedures, but he will also talk about the things that are used in creating the stored procedures that will do backups, copy a database, and/or restore a database. In this first video in the series, Scott will walk you through the process of creating a stored procedure that will backup a database, a very essential maintenance task.

Highlights from this video:

• Building a backup database stored procedure from scratch
  • Requirements
• About using SYSNAME
• How to set required/default parameters
• Two types of parameters with stored procedures
  • Inputs
  • Input Output

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: 11:45 (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, backup, copy, restore, database, automate, automation,