SQL Server Performance Forum – Threads Archive
Snapshot replication becomes DisabledI have a small database of data that is used as a central repository, 5 tables are snapshot replicated across a network to to Multiple machines.<br /><br />I set up Snapshot agent to run on a daily basis at midnight and the publication agents to run 1 a day at certain times. [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />After a few days i started to recieve reports of data not being present on the satalite databases. On checking the snapshot agent i found it had run once (the night i set it up) and the schedule was now set to Disabled. Thinking I had set the replication up incorrectly I edited the agent profile to enable the scedule and waited a few days.<br /><br />The snapshot ran that night but once again reset the scedule to disabled.<br /><br />Am i doing somthing wrong ???? [<img src=’/community/emoticons/emotion-6.gif’ alt=’‘ />!]<br /><br />Please Help.<br /><br />
Did you set in schedule, no end date?
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Check the SQLAgent log and SQL error log for any information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Ok idiot of the week goes to Me for setting the end date = to start date no wonder it kept disabling the schedule thanks for you help. Derek.