SQL Server Performance

The initial snapshot for publication xxxxx is not yet available

Discussion in 'Performance Tuning for SQL Server Replication' started by boutwater, Aug 25, 2008.

  1. boutwater Member

    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,
    boutwater, Aug 25, 2008
    #2

  2. melvinlusk Member

    What is meant by "had a user change one of the user login's"? Was that login being used by the SQL service account?
    melvinlusk, Aug 26, 2008
    #3

  3. ghemant Moderator

    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
    ghemant, Aug 26, 2008
    #4

Share This Page