How do I retrieve the sensitive data from the logs?

How do I retrieve the sensitive data from the logs?

​​​Answer:

When you have done a migration with sensitive data detection activated, you might want to retrieve the actual records.

  1. Use SQL Management Studio to connect to your SQL Azure.
  2. Go to the appropriate Database and Table.
  3. Use this statement to get the data back: SELECT * FROM [dbo].MyTable WHERE severity = 2 ​​
Was this article helpful?
0 out of 0 found this helpful