In the GUI under the "Options" tab, the third checkbox down is "Force
restore over existing database". You need to check that one to put your
copy of the production database in the files currently used by the training
database.

Or optionally, you could drop the current database on the training server,
then restore from your production backup.

But in either case you will need to synchronize the users in the databases
to the master sysxlogins. For that you will need to look at
sp_change_users_login with the "update_one" option (see BOL).

Hope this helps.

Tom

-----Original Message-----
From: Trice Liz Contractor AFSVA/SVSN
[mailto:Liz.[Email Address Removed] Thursday, August 22, 2002 1:45 PM
To: [Email Address Removed] How to copy one database from one SQL7 database to another SQL7
s erver database.


Can someone give me the best method to do this. Basically I have one live
server and I want an exact copy of what I have on a training server as a
backup.
I tried backing up the database and restoring it to the training server but
I get an error.

"Backup set hold a backup of a database other then he existing AFSVA_DB
Operation terminated abnormally."

By the way I was doing this procedure via the SQL 7 enterprise GUI.
Backup/Restore.

Should I write a script instead or what. On SQL 2000 there is a copy db in
the wizard. I'm kind of at a lose.

Thanks everyone for your help in advance.

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page