?
Solved

SQL 2008 Change Tracking Retention Period failing

Posted on 2010-11-17
9
Medium Priority
?
1,212 Views
Last Modified: 2012-05-10
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!
0
Comment
Question by:rmm2001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 41

Expert Comment

by:ralmada
ID: 34157646
0
 
LVL 7

Author Comment

by:rmm2001
ID: 34157882
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?
0
 
LVL 41

Expert Comment

by:ralmada
ID: 34157943
>>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...
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 7

Author Comment

by:rmm2001
ID: 34157963
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

0
 
LVL 41

Expert Comment

by:ralmada
ID: 34158090
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?
0
 
LVL 41

Expert Comment

by:ralmada
ID: 34158260
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
0
 
LVL 7

Accepted Solution

by:
rmm2001 earned 0 total points
ID: 34158697
1st post: I don't know if I have or not...I generally don't manage the hotfixing. I'll figure out how to check to see if they're there. I'm assuming I have to restart the service in order for them to get applied?

And no on the replication. Just a basic server - couple of databases on it. 2/3 change tracking enabled
0
 
LVL 41

Assisted Solution

by:ralmada
ralmada earned 2000 total points
ID: 34158748
>>1st post: I don't know if I have or not...I generally don't manage the hotfixing. I'll figure out how to check to see if they're there. I'm assuming I have to restart the service in order for them to get applied?<<
Yeah, you should make sure you have the latest patch applied. That will probably require you to restart the service, so just be careful with the timing.

0
 
LVL 7

Author Closing Comment

by:rmm2001
ID: 34216196
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!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question