The initial snapshot for publication xxxxx is not yet available | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

The initial snapshot for publication xxxxx is not yet available

I’m getting this error on the distributor for my replication. It says succeeded, but than says this and won’t update the replicated data. I had a user change one of the user login’s last Friday and that is what started this mess, but I can’t seem to resolve it. I would rather not drop the subscription because I have archived data in there that will be lost if I recreate the subscription. Is there any way to figure out why this error is coming up and solve it? Thanks,

What is meant by "had a user change one of the user login’s"? Was that login being used by the SQL service account?

see if the snapshot folder is their and by any chance not deleted by anybody and it has a proper NT permission for the SQLServer Agent account….also check the snapshot agent job history for the exact error message which will help u rectify this issue

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |