Post reply

Four files for each article in snapshot folder?

  • September 15, 2009 at 5:23 am

    #204680

    When I setup a snapshot replication then for every article I found four files in the default snapshot folder: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\ReplData\unc\LuckyPC_ADVENTUREWORKSDW_SNAPSHOTTEST\20090915164524. Can anyone tell me why does this create four files for every article?

    -lk

  • September 15, 2009 at 5:43 am

    #1053700

    A list of the files would have helped to provide a definitive answer to the question. Are they possibly:-

    *.SCH - table definition

    *.DRI - definition of the indexes and constraints

    *.TRG - table triggers

    *.BCP - the actual data

  • September 15, 2009 at 7:50 am

    #1053774

    Thanks.

    Can you tell me what is the correct way of reinitialization? I set up snapshot replication. Now I had to drop one artilce from replication. But even after reinitialization from publication, the object still shows that there in the subscription database.

    I went ahead and dropped the particular files for that article from the snapshot folder but this didn't work out? I restarted the snapshot job also. Is anything I am missing?

    -lk

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply