Home Forums SQL Server 2005 SS2K5 Replication Advice about how to refresh a test database that is acting as a publisher, distributor, and subscriber (not replicating to other servers though) RE: Advice about how to refresh a test database that is acting as a publisher, distributor, and subscriber (not replicating to other servers though)

  • February 4, 2013 at 10:25 am

    #1584034

    SSIS is definitely the way to go. Backup/restore would require dropping/re-setting up replication.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]