Configuring a Debug / Test Server

  • I would like to setup a debug / test database server.  I plan to restore from the production server's nightly backup using Scheduled Jobs.  I am concerned with SQL Agent running on the test server because the database backup I am restoring from is a replicated database.  Will this cause any problems?

  • None that I can think of. Done this for several years.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • I appreciate the feedback.  It wasnt until I gave it some more thought that i realized the Master Database contains the db replicated flag.  Thanks again.

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

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