New SQL Server Video Tutorial: Part 4- Writing the Stored Procedu re to Restore a Database

Part 4- Writing the Stored Procedure to Restore a Database - view details

After you complete your stored procedure to backup a databse, you can then create a stored procedure to restore a database from those backups. With a stored procedure like this, you will have several credentials to first set. In this fourth video in the series Scott will cover those parameters and demonstrate the exact way to create this awesome stored procedure.

Highlights from this video:

• Required parameters for restoring a database
• Creating a base restore database command
  • Why does the command fail?
• Obtaining the logical file names

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, database, restore, file,