what does 'sp_addumpdevice'  mean and where does it sit?

Posted on 2004-11-26
Medium Priority
Last Modified: 2012-08-13
How do you create the 'sp_addumpdevice' and what does this statement mean; Also will this be used for all databases?

Question by:Etravels
1 Comment
LVL 16

Accepted Solution

muzzy2003 earned 200 total points
ID: 12680587
sp_addumpdevice is a system stored procedure that adds a backup device (disk, named pipe or tape) to the instance of SQL Server in question. You can't create it - it is there already. The backup device that this creates can then be used when backing up any of your databases. Look up sp_addumpdevice in SQL Server Books Online for a full description.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question