Results 1 to 3 of 3

Thread: Backup device

  1. #1
    Join Date
    Nov 2003
    Posts
    19

    Unanswered: Backup device

    Hi

    is there a stored procedure which allows me to query if there is an existing backup device? or which gives me a listing of existing backup devices?


    Thanks!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    SP_HELPDEVICE and in SQL 2K this is used for backward compatibility with earlier versions of SQL Server.

    Refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2003
    Posts
    19

    Smile

    Thanx Satya. Appreciate.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •