Test Database Copy

[Justin Allen]

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?

Justin

[Simon Hayes]

"Justin Allen" <co****************@hotmail.com> wrote in message
news:3b*************************@posting.google.co m...

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?

Justin

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

Simon