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)

  • As with almost everything we do there are multiple ways of doing a task. A method I use to refresh test databases from production is with a Windows Scheduled task to call a PowerShell script that copies the database to test and then run an Job that restores the database. Not replication but it should work for you as well.

    ______________________________
    AJ Mendo | @SQLAJ