CODEWITHSUNDEEP
sql-server
chrismay
chrismay

Reputation: 1384

How to create a sql server staging/testing environment that is kept somewhat up-to-date with production?

We have a couple production SQL Server machines running something like 50 database catalogs that are used by a number of applications.

Right now we have a dev sql server that has copies of all these database catalogs for us to develop against, but what I'd really like is for another server to be a "staging" or "test" environment that closely mirrors our production environment.

Ideally, we like to have something that can automate the process of duplicating a production database. I assume our best option would be some type of scripted restore of production backup files, but I'm open to anything.

Upvotes: 2

Views: 2359

Answers (1)

David Atkinson
David Atkinson

Reputation: 5899

Is there a reason why you can't simply automate the backup restoration of the last production backup to a test server as a scheduled task?

Upvotes: 0

Related Questions