Showing posts with label allows. Show all posts
Showing posts with label allows. Show all posts

Tuesday, March 20, 2012

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!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.|||Thanx Satya. Appreciate.