New SQL Server Video Tutorial: Part 5 - Writing the Stored Proced ure to Copy a Database

Part 5 - Writing the Stored Procedure to Copy a Database - view details

Continued in this fifth video in the series, Scott will show you how to create a handy stored procedure to copy a database by building off your knowledge from the backup and restore procedures.

Highlights from this video:

• Required parameters for the copy database stored procedure
• Working with the backup and restore procedures
• Assigning the datafile and the log via dynamic sql
• Demo of backup/restore/copy procedures

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 300 (Intermediate)
• Length: 13:15 (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, file, copy, restore,