Backup file location

rsnorrisrsnorris Posts: 5
edited May 18, 2011 6:00AM in SQL Virtual Restore 2
Can anyone suggest how to find the backup file location of a virtually restored database? Ideally using TSQL code.

Many thanks
· Share on Twitter

Comments

  • javenjaven Posts: 50
    Hi, This is tracked internally, you can get some info from the openstatus.dat file which ma help, but there is no way to get this info by TSQL without writing your own xp. We can table this as a suggestion for the product in the future however.
    Jeffrey Aven
    Product Management - HyperBac Technologies
    Red Gate Software
    · Share on Twitter
  • sqlstevesqlsteve Posts: 5
    The openstatus.dat doesn't have this information in my installation. If one was to write an XP what would it do? Where is the information?
    · Share on Twitter
Sign In or Register to comment.