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.
- Use SQL Management Studio to connect to your SQL Azure.
- Go to the appropriate Database and Table.
- Use this statement to get the data back: SELECT * FROM [dbo].MyTable WHERE severity = 2