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.
MS Sql Server LazyDBA home page