Simple(?) Backup - Restore Question

Greetings,

Been lurking for a while, and new to MS-SQL, and didn't see an answer to a question that I have.

Running MS-SQL2000. SP2

Have a need to make a backup of a database at midnight on the last day of the month and to then make that data available to Accounting for end of month reporting.

The easy part was to schedule a full backup to occur at midnight on the last day of the month. The db was backed up to the file name Chorro_MonthEnd.BAK.

I then added to the scheduled job the following T-SQL:

RESTORE DATABASE [Chorro_MonthEnd] FROM DISK = N'D:Data FilesMicrosoft SQL ServerMSSQLBACKUPChorro_MonthEnd.bak'

The question(s) that I have are:

1) The data in the db Chorro_MonthEnd should be over-written with the data from the restore?

2) Since the Chorro_MonthEnd db exists, is MOVE necessary as part of the restore command? I have been told that if you don't use the MOVE command, it puts the original file names back into wherever directory structure they were backed up from. The concern is that it could overwrite the original db MDF/LDF files.

What we are trying to avoid is having someone from the IS side of the house having to be on-site to restore a db for Accounting. IS type get cranky if they don't get enough sleep :D

Thanks in advance....


Brian