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 |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2001-11-29 : 04:12:29
|
| Hi,(sql 2000)I have to know the datetime that a backup device includes.how to know that by code (NOT EN).the sp_helpdevice is not enough - any other way ?thanksNoamNoam Graizer |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-11-29 : 07:47:46
|
| If I understand you correctly, you want to find out the contents of the backup device. In that case, try RESTORE HEADERONLY command (see BOL for syntax) |
 |
|
|
|
|
|
backup device metadata