Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've a sql server database that is configured to work with old software, i've no details about the software, but i know that DB uses replication.

the DB size dramatically increases. When i investigate some tables sizes, i found these ones with these sizes:

MSmerge_bi_D89534BB1063408B942B62C6B98C1E51 | 22.731987 Gigs MSmerge_bi_6C3E9C2ED4824946B65D575B7F84C225 | 16.62373352 Gigs MSmerge_bi_D89D3BA8BD334415AF6D51F0561344F3 | 14.91197205 Gigs MSmerge_bi_4BE323F1031445C78894AA625FB6BF50 | 3.80770874 Gigs MSmerge_bi_4CDB8F1078C74B33820DA52F55DAA57A | 2.638702393 Gigs MSmerge_bi_6BDBDB2589364C609E303B85D8C30155 | 2.328575134 Gigs MSmerge_bi_8DF8751AAE234EF88DBE64E0D947DECD | 1.122215271 Gigs MSmerge_bi_EE8A4730E51247E5A4719BBC0DAB304E | 1.069778442 Gigs MSmerge_bi_2A397A3824BA455EAE4F6689623A46AC | 0.340202332 Gigs

any suggestions on how to deal with these huge tables, and is it safe to delete ? (i'm not expert with db Administration)


migration rejected from Sep 27 '13 at 4:31

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, RolandoMySQLDBA, Mat, Mark Storey-Smith, StanleyJohns Sep 27 '13 at 4:31

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, RolandoMySQLDBA, Mat, Mark Storey-Smith, StanleyJohns
If this question can be reworded to fit the rules in the help center, please edit the question.

That's really not that big. – Jason Carter Apr 9 '13 at 13:45
Actually they are big. – Brandon Williams Apr 9 '13 at 15:25
What is your retention period set to and do you have metadata cleanup disabled? – Brandon Williams Apr 9 '13 at 15:37