asked on

SQL 2008 Change Tracking Retention Period failing

HI guys -

I have a database set up with change tracking. Initially I set it up with 3 days as the initial repletion period. Then I changed it (via the interface in ssms) to 30 days. Clicked ok. I checked in the cdc table ( I forget which one) to make sure that it was actually set to 30 and not to 3 and it said 30.

Problem is - it's still dropping my changes after 3 days. So I know I did something wrong.

Any clues what I did/how I can get my data to stay around longer without rebuilding the entire thing?

Thanks!

ralmada

This is sort of the opposite, but maybe it helps you

http://www.mskbarticles.com/index.php?kb=2446860

http://support.microsoft.com/kb/973696

rmm2001

ASKER

Sadly no...that just confirms that my retention period is set to 30. And my retention period units are set to 3. Do my retention period units need to be set to 1?

ralmada

>>And my retention period units are set to 3<< I'm not following you here. I think retention period unit should be "Days" not a number...

rmm2001

ASKER

Here's what I get when I do a select * from sys.change_tracking_databases .. It's database_id, is_auto_cleanup_on, retention_period, retention_period_units, retention_period_units_desc (kinda jumbled in the thing below)

database_id is_auto_cleanup_on retention_period retention_period_units retention_period_units_desc
----------- ------------------ ---------------- ---------------------- ------------------------------------------------------------
7           1                  30               3                      DAYS

Open in new window

ralmada

Oh, I see it now.

Regarding the links I've posted above, so basically you're saying that you have already installed the hotfixes suggested in the links above aren't you?

ralmada

Also are you running on a replicated database? Check this link for some pointers
http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/320c546e-e454-4da6-bd3b-aa5a3b5d9ebb

ASKER CERTIFIED SOLUTION

rmm2001

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

ralmada

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rmm2001

ASKER

It was a good shot in the dark but didn't seem to work. I just took off the "auto cleanup" and will do that manually and hope I don't lose my stuff that way. Thanks for the help!