Copy SQL instance for test upgrade -- sql server replication

Bill Clark
10/18/2007 2:53:31 PM

We have an imaging product that is running on a Win2K SP4 server utilizing
SQL Server 2000 Standard Edition for it's database. We are preparing to
upgrade the imaging product but there is a history of bad upgrades. So, I
need to create a copy of the production server to a new server and test the
upgrade procedure there. How can I copy SQL Server and it's databases to a
new box? Is there a TID somewhere I haven't found or some othe resource?
The imaging product is fairly straight forward, but I'm haning on the SQL
side. Thanks.

Bill

Hilary Cotter
10/19/2007 5:55:54 AM

Either use a backup and restore to restore the databases to the new server,
or try to detach and reattach the databases on the new server.

You can use DTS to send the logins to the new server.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : Copy SQL instance for test upgrade