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.

No comments:

Post a Comment