Reputation
2,001
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 13 32
Newest
 Announcer
Impact
~160k people reached

Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
We've been running CDC on an async mirror for several months. It's been working great for tbe data warehouse to query the snapshot. It wasn't until we moved the mirror partner to a new datacenter that all this became an issue. Setting up mirror and then CDC, no problem. CDC and then mirroring... not so easy.
Oct
4
awarded  Nice Answer
Oct
4
accepted Doing a point in time restore with CDC enabled; Possible?
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
You know what... I just had an epiphany... do a full restore with keep_cdc on the new box. That will build cdc out, then start you multi file restore over the top of it without keep_cdc to do your point in time recovery. Ok, I'm squared away now.
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 36 characters in body
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
So restoring to a different database, a new database, or a database that will be a mirroring partner is still a no? I read this same article but it left me wondering about the scenarios above in a multi file scenario.
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 15 characters in body
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 131 characters in body
Oct
4
asked Doing a point in time restore with CDC enabled; Possible?
Sep
29
awarded  Popular Question
Sep
11
comment Do you know an easy way to generate one record for each hour of the past 12 hours?
Yeah for number tables - they're all the rage.
Sep
11
revised Does SQL manage foreign key constraints in terms of Insertion?
added 4 characters in body
Aug
23
awarded  Popular Question
Jul
31
revised Location of Maintenance Plan's Back Up Database Tasks information (SQL Server 2005)
added 9 characters in body
Jun
15
awarded  Popular Question
May
15
awarded  Caucus
May
1
awarded  Enlightened
May
1
awarded  Nice Answer
Apr
27
awarded  Yearling
Apr
13
awarded  Nice Question