SQL 7/NT4/ADSM Connect Agent 1.1.1A

Trying to restore a production database into a new database created for the
recovery.  Getting the following error:

        Error: SQL server errors encountered. DB_LIB message: The file
e:\mssql7\data\dbname.mdf
        cannot be used by Restore.  Consider using the WITH MOVE option to
identify a valid location for this file.

Read on this site that for SQL 7.0 they require the original database file
(.mdf file) to NOT exist before doing a "restore into".  The suggestion was
to rename the database .mdf file to something else or restore to a different
SQL server.

However, DBA has told me that the database is empty.  It was created just to
house this load from production.  What are we missing?

Thanks,

Maria

Maria Ragan
Mid Range Systems
Bear Creek Corporation