Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
6
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Apr
22
awarded  Popular Question
Jan
4
awarded  Teacher
Nov
15
awarded  Scholar
Nov
15
accepted Restore all applicable files in a backup device in T-SQL
Sep
26
comment Restore all applicable files in a backup device in T-SQL
Thanks Stuart, this was helpful in some ways, but it just works for backup devices that were created on the same server. It uses information about the devices from system tables, which it seems get in there when the backup is running on the same server. Adding a device to the server, still doesn't put the information about the files into the msdb tables. Because the restore happens on a different server I had to read the content of the device from the device itself (see my answer). Thanks anyway.
Sep
26
answered Restore all applicable files in a backup device in T-SQL
Sep
25
awarded  Supporter
Sep
23
awarded  Student
Sep
23
asked Restore all applicable files in a backup device in T-SQL
Jun
1
awarded  Autobiographer