Sunday, March 11, 2012
[REPL] server config for distributor server?
Our production DB is 30GB and we are replication about 60% of the data to another server.rack mountable
dual processor with hyperthreading
100 GB RAID (disk space is not that important, but might as well make it RAID)
16 GB Memory (from what I understand memory is the most important attribute)
any other suggestions...?
Sunday, February 19, 2012
[Expired subscription clean up] job failing
The "Expired subscription clean up" job at the distributor keeps failing with the following error. Any ideas what it could be?
Message
Executed as user: domain\servicesql. The Distributor has not been installed correctly. [SQLSTATE 42000] (Error 20036). The step failed.
Thanks,
Priyanga
I came accross the following link which provides a workaround to the problem.
Thanks Narayana!
http://vyaskn.tripod.com/sql_server_2005_expired_subscription_cleanup.htm
Cheers,
Priyanga
[Expired subscription clean up] job failing
The "Expired subscription clean up" job at the distributor keeps failing with the following error. Any ideas what it could be?
Message
Executed as user: domain\servicesql. The Distributor has not been installed correctly. [SQLSTATE 42000] (Error 20036). The step failed.
Thanks,
Priyanga
I came accross the following link which provides a workaround to the problem.
Thanks Narayana!
http://vyaskn.tripod.com/sql_server_2005_expired_subscription_cleanup.htm
Cheers,
Priyanga