Options
Select query on BackupSetDatabase?
hemantgaur
Posts: 27
I am comparing two databases. One of them is BackupSetDatabase. I would like to run a select query on this backup. What is the best way of doing this? Is there a Red-gate API which can give me the result? Do you have an example of this in your knowledge base?
Would deeply appreciate your help on this.
Thank you.
Would deeply appreciate your help on this.
Thank you.
Comments
You cannot use the API to runs specific queries against a backup file, it only supports using the backup file as a data source for the comparison.
Do you want to be able to interrogate the offline backup file?
but if not, then is there a way to do it against an attached database?
http://msdn.microsoft.com/en-us/library ... ction.aspx