Snapshot or backup restoration -- sql server new users

Jim in Arizona
8/14/2007 9:49:41 AM

We have two SQL2000 standard machines (two seperate boxes). One is our
primary, production database and the other is a testing database which has a
copy of the database from the production server.

Being tasked with making the testing server up-to-date, I was wondering
which would be a better way to update the test box. Should I just copy the
backups over to the test box and restore them, or could I do some kind of
single, one way snapshot replication? I've been looking a little bit at
snapshot replication but I'm not familiar with it enough to be comfortable
with using it. If I thought I could just do a single snapshot to make
everythign up to date, I would. But, is this the better way?

TIA,
Jim

Andrew J. Kelly
8/14/2007 1:43:58 PM

A backup & Restore will most likely be the cleanest and easiest approach. If
the db is large consider using one of the 3rd party backup & compression
tools to speed up the process.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

sql server new users : Snapshot or backup restoration