469 reputation
516
bio website
location Sydney, Australia
age
visits member for 2 years, 10 months
seen Dec 8 at 22:10

Nov
14
comment Find out who ran a query using transaction log backups
Apex SQL Log worked a treat
Nov
14
accepted Find out who ran a query using transaction log backups
Nov
14
comment Find out who ran a query using transaction log backups
@Kin Apex SQL was perfect for this. If you want to make that an answer I'll certainly accept it.
Nov
13
comment Find out who ran a query using transaction log backups
@Kin, does Apex SQL Log work after the fact, or did we need to have it running at the time?
Nov
13
comment Find out who ran a query using transaction log backups
That's all gone a bit over my head. We've restored the database to the point in time right before the change happened. It happened last night (15 hours ago) so it's well and truly committed. The data has been fixed, but what we're trying to work out is what login was used to run the query.
Nov
13
asked Find out who ran a query using transaction log backups
Nov
4
awarded  Popular Question
Oct
27
comment Change Data Capture not running when Mirror is Suspended
Our link to DR was broken overnight and CDC data wasn't processed again. Still can't find anything on Google. Might need to go to Microsoft.
Oct
9
awarded  Notable Question
Sep
12
accepted Cube Processing vs Database Processing
Sep
12
answered Cube Processing vs Database Processing
Sep
10
asked Cube Processing vs Database Processing
Aug
20
revised Change Data Capture not running when Mirror is Suspended
added 35 characters in body
Aug
20
comment Change Data Capture not running when Mirror is Suspended
@mrdenny - sounds plausible. We are running the mirror as async normally as we don't want the latency we get with sync and the CDC data works as expected. Like I said though, the Log Reader being disabled sounds plausible
Aug
20
comment Change Data Capture not running when Mirror is Suspended
I think so. We only have the mirror setup in production so it's not easy to test on demand, but the last 2 days we've paused the mirror and the last two days the cdc data didn't process while the mirror was paused.
Aug
20
asked Change Data Capture not running when Mirror is Suspended
Aug
6
awarded  Nice Question
Jul
19
awarded  Yearling
Jul
9
awarded  Popular Question
Jul
2
awarded  Curious