CraigSomberg (cs******@dwr.com) writes:
I have a production database that is in the low gigabyte size and
growing steadily. No issue there.
That's not a VLDB. :-)
I wish to completely refresh the development database daily on a
second server. What is going to be the fastest easiest way to do this
with hindering performance on the production system ?
Well, you need to take backups of the production machine anyway, so just
restore the database from the backup. True, if the developerment database
is on the same machine, this takes some load.
Log shipping was mentioned, but assuming that you do changes in the
development database for testing, development etc, I don't think this
works.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp