Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 problem with a 15GB distribution DB

Author  Topic 

vde
Starting Member

3 Posts

Posted - 2010-11-16 : 08:55:02
Hello All,

I am new to MS SQL and I apologize if I ask some strange questions.

I have the following problem my distribution db is 15 GB and I have located the source it is the MSmerge_History 13+ gb.
My question is can I safely delete the entries for this table manually or is there a job that is responsible to do so? (entries date from 2008)

Thank you
Viktor

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-11-16 : 10:27:01
saw this

and this?
Go to Top of Page

vde
Starting Member

3 Posts

Posted - 2010-11-16 : 10:57:01
Hi Russell, I found this yes but I wanted confirmation from another source because if some errors occur of this manual deletion action it would cause me realllly big problems!

Regards
Viktor
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-11-16 : 12:13:48
backup the distribution db first, then go ahead and delete the records
Go to Top of Page

vde
Starting Member

3 Posts

Posted - 2010-11-17 : 02:32:46
Thank you
Cheers
Viktor
Go to Top of Page
   

- Advertisement -