sql server replication snapshot bulk-copy data file Import

• rembersu-432095

  Ten Centuries

  Points: 1300

  More actions

  October 15, 2012 at 6:07 pm

  #268554

  Hi all,

  is there any way we can manually bcp in a (sql server replication snapshot bulk-copy data file) .bcp file extension file into a SQL database table. we have a snapshot file from our transaction replication snapshot which is from a OLD snapshot which we want to restore out side of replication and restore some important data. any help would be really appropriated.

  Thanks In Advance.

  Rembersu

• rembersu-432095

  Ten Centuries

  Points: 1300

  More actions

  October 15, 2012 at 8:40 pm

  #1549362

  Update : was able find the solution to import replication .bcp data file from the below approach

  http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/31390e12-1139-418b-bba8-24aac1a30c2b

  Thanks,

  Rembersu