Monthly Archives: November 2007

Replication Agents and Maintnance Jobs

There are bunch of agents and maintnance jobs to perform replication in SQL Server 2005. The following is their running location and sumary: SnapShot Agent: Runs on distributor; used by All type replications.There is one agent for each publication; It … Continue reading

Posted in SQL server 2005 | Leave a comment

Failover Logship Primary Database to Secondary Database

Log shipping can be set up between one primary database and multiple secondary databases. The secondary databases can be in recovery mode, which is inaccessible, or in Standby mode, whose data is readonly for reporting purpose. Note that the data¬†latency … Continue reading

Posted in SQL server 2005 | Leave a comment