Backup file location

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Moderators: eddie davis, Colin Millerchip, fionag

Backup file location

Postby rsnorris » Wed Apr 06, 2011 5:01 pm

Can anyone suggest how to find the backup file location of a virtually restored database? Ideally using TSQL code.

Many thanks
rsnorris
 
Posts: 3
Joined: Wed Apr 06, 2011 4:57 pm

Postby javen » Fri Apr 08, 2011 9:52 pm

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
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am

Postby sqlsteve » Wed May 18, 2011 11:00 am

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?
sqlsteve
 
Posts: 3
Joined: Wed May 18, 2011 5:48 am


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests