Test Database Copy -- sql server (alternate)

contactjustinallen NO[at]SPAM hotmail.com
2/13/2004 4:22:02 AM

I am using SQL 2000, 2000 Server. I need to find out how to schedule a
database export import. I have a production database that I need to
easily copy to a test database occassionaly. When I run the DTS
function it won't import the primary keys. It errors. I need to get
all the tables and views from one database into the temporary database
that we use for testing without recreating the temp everytime. Any
suggestions?

Simon Hayes
2/13/2004 6:57:12 PM

[quoted text, click to view]

The easiest way is probably to backup the database, copy the backup file and
restore it. See "Copying Databases" in Books Online.

Simon

sql server (alternate) : Test Database Copy