We have a remote vendor who sends updates to a SQL db that lives on one
of our SQL servers. From time-to-time the updates are determined
undesirable and before performing a restore in production  we want to be
able to send them a portable copy so they can determine the root cause
of the problem before moving forward. I have had this situation come up
before and scoured over the TDP documentation and found no clear
definition of how to complete the task. 

 

Is there a way to perform what I will call a portable "flat file"
restore of SQL databases from TSM without it affecting the production
copy that is live on the SQL server?

How do you handle these requests?

 

All feedback appreciated....TIA

 

Rick Adamson

Jacksonville, FL