Post reply

What are the files created when we create the SnapShot Replication

  • May 23, 2011 at 3:22 am

    #237893

    What are the files created when we create the SnapShot Replication in Sql Server and in the disk

  • May 23, 2011 at 4:35 am

    #1328387

    what do they mean?

    * The *.BCP files contain the data from the Address table. In SQL 2000 there would only be one file created, the rules changed a little in SQL 2005. See SQL Server 2005 BCP Partitioning by Paul Ibison for a great explanation of the change.

    * The address_2.idx file contains a script to create the indexes on the subscriber

    * The address_2.sch file contains the script to create the table and the replication specific stored procedures on the subscriber

    * The address_2.pre file is a pre-snapshot script (though not the same as the one you can configure manually) that by default drops the table on the subscriber if it exists

    At this point the work of the snapshot agent is done. In the next article we'll look at what the distribution agent does with the files and how/when the files get cleaned up.

  • May 23, 2011 at 4:55 am

    #1328399

    Please find details.

    schema (.sch); data (.bcp); constraints and indexes (.dri); constraints (.idx); triggers (.trg):for updating Subscribers only; compressed snapshot files (.cab).

    Attached is the link.

    http://64.4.11.252/en-us/library/ms151795(SQL.90).aspx

    M&M

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

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