-
1. Re: Where to find backgrounder query used to refresh TDE?
Jeff StraussApr 5, 2016 3:06 PM (in response to Olga Yazovskaya)
see if the attached doc helps. I wrote it about a year ago, it may give you some clues. At some point, I will publish to my blog after re-reviewing / cleaning it up. But for the time being, it may help you.
-
2. Re: Where to find backgrounder query used to refresh TDE?
Damien Lesage Apr 6, 2016 1:09 AM (in response to Olga Yazovskaya)1 of 1 people found this helpfulYou could also try to find it in your database log. Some databases have a table registering all the queries that were executed by users. You could try to match the user / timestamp.
-
3. Re: Where to find backgrounder query used to refresh TDE?
Jeff StraussApr 6, 2016 3:41 AM (in response to Damien Lesage)
this is a good suggestion, we didn't really have this option as we would have to work through our DBA who seems to always be busy.
-
4. Re: Where to find backgrounder query used to refresh TDE?
Olga Yazovskaya Apr 20, 2016 11:46 AM (in response to Jeff Strauss)Hi Jeffrey,
Thank you for your reply, you article helps to understand the task better , but there is no query logged
-
5. Re: Where to find backgrounder query used to refresh TDE?
Olga Yazovskaya Apr 22, 2016 12:46 PM (in response to Jeff Strauss)Hi Jeffrey,
That is what I have to do. And since I don't have an access to the DB I need to keep bugging a DBA.
-
6. Re: Where to find backgrounder query used to refresh TDE?
Olga Yazovskaya Apr 22, 2016 12:47 PM (in response to Damien Lesage)Hi Damien,
This solution is little more complex when you don't have DB admin access
-
7. Re: Where to find backgrounder query used to refresh TDE?
Jeff StraussApr 22, 2016 12:58 PM (in response to Olga Yazovskaya)