Restoring SQL Server 7 databases

[DavidMarcus]

I frequently restore SQL Server 7.0 databases from backup files that users send me. I use enterprise manager to do this. I am always overwriting an existing database. The MDF and LDF parhs, and sometimes the file names, in the backup set are inevitably different from those in my database. So, I have to manually change the 'move to physical file name' so I can do the backup.

My question is, "Is there any way to have the existing physcial file name used automatically in this situation?"

Thanks! I am using Crystal Reports 8.0 and using RDC to embed them in our applications.

David Marcus
GMT Corporation