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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-11-17 : 05:40:34
|
| Dear All,the error initial snapshot for the publication 'abc' is not yet available again stopped the replication.i'm using transactional replication push subscription. i dont know why sql server 2005 troubling this much. previously i've no choice except generating the new snapshot. while trying to put pull subscription, problems came with the permissions on the folder to the particular user.1)please let me know have you faced the problem said above?2)please let me know the permissions to the user to put pull subscription....3)is there anything i need to change in the distributor properties to select pull subscription??please help me in this regardArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-17 : 06:20:18
|
| stop the distribution agent, right click on it, select agent properties, and make sure sa is the job owner is sa. Right click again and select the verbose history agent. Restart your agent, and see if this helps.If not, reinitialize this subscription and try again. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-17 : 06:44:53
|
| Sodeep, can you please tell me where can i find distribution agent...ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-17 : 06:56:21
|
| in Distributor properties on subscriber |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-17 : 07:10:27
|
| i've seen the verbose history agent. i've selected that instead of default agent. but i dont know how can i stop and start the distribution agent...where can i find that option???thaks in advance sodeepArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
initial snapshot not yet available error again