Welcome to
Sign in
|
Help
in
Intrebari generale (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
Intrebari generale
»
Re: Probleme dimensiune tabele metadata in cadrul replicarii merge???
Probleme dimensiune tabele metadata in cadrul replicarii merge???
Last post 11-23-2010, 9:25 PM by
xmldeveloper
. 1 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
11-10-2010, 12:16 AM
8476
werty80
Joined on 11-06-2007
db_owner
Probleme dimensiune tabele metadata in cadrul replicarii merge???
Reply
Quote
Am o replicare merge, cu retention time never expires, datorita faptului ca am un volum foarte mare de date
ma confrunt cu marirea considerabila a
tabelelor ce contin metadata(ins, delet,up).
Ce probleme pot aparea daca sterg manual datele din aceste tabele + reindexare(indexul ajunge la nivelul 1 Gb pe unele tabele) dbo.MSmerge_genhistory,MSmerge_generation_partition_mappings,MSmerge_tombstone,MSmerge_contents.
Report abuse
11-23-2010, 9:25 PM
8512
in reply to
8476
xmldeveloper
Joined on 01-18-2006
Bucharest, Romania
Rank NA
Re: Probleme dimensiune tabele metadata in cadrul replicarii merge???
Reply
Quote
Ati incercat sa folositi
sp_mergecleanupmetadata
?
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro
Report abuse