开发者

Using T-SQL to get contents of backup media

开发者 https://www.devze.com 2022-12-18 20:35 出处:网络
In SQL Server Management Studio (I have 2008), I can see the contents of the media i have backed up to, be it disk or tape.I can see information such as what files it currently includes, the dates the

In SQL Server Management Studio (I have 2008), I can see the contents of the media i have backed up to, be it disk or tape. I can see information such as what files it currently includes, the dates they were backed up, etc... Is there a way to do this in T-SQL? I would like to specify a device (which is linked to a file location) and query it for 开发者_StackOverflow社区its contents. Any thoughts?


You can start SQL profiler, then carry out the actions in Management Studio to display the information you require, then look in the profiler output to see what has been executed in the background to get you that info.

My guess is that these tables/catalogs are being queried:

sys.backup_devices

0

精彩评论

暂无评论...
验证码 换一张
取 消