What is the easiest way to copy an sql 2000 server database from one webserver to another?

Question

I have a database set up on a remote sql 2000 server and I want to duplicate the same database on another remote server for testing purposes. Is there a way to do this without manually creating the database again?

Answer 1

There are two Good ways to do it:



1. Using Import & Export wizard, you can transfer the entire database from one server to another.



2. Simply FTP the data file (.MDF) and then attach the file using the sp_attach_db command.

Answer 2

There should be a way to save the database as a sequence of SQL queries, and then run them on the other webserver. I have not dealt with sql 2000 per se

Answer 3

You can use SQL Server's Utility to Export Data to another SQL Server or an alternative is that you can take backup of your database from one server and restore it at another one!

Answer 4

use the replicaton service or unmount the database, do a copy (ftp if needed) and a remount.