Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wafi
Starting Member
12 Posts |
 Posted - 2004-04-17 : 05:30:20
|
| Hi All,, I want to get alist of backup devices for a selected database ex : Northwind Database i need to get the a list of back devices for this db any one know how the query could be writtenbest regardsWafi Mohtaseb |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-04-17 : 11:29:42
|
| Well...you might want to take a look at sp_helpdevice in BOL and see if it can be of any use. SELECT * FROM master.dbo.sysdevices will give you all devices for the entire database--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
|
|
|
How Can i Get a list of Back devices