Restore database overwriting databases without the Replace option (SQL Server 2000)

Hi everybody,
I'm trying to figure out why my installation of SQL Server 2000 is allowing
databases to be restored that overwrite an exisitng databases, when I do
*not* specify the replace option.
Is the server currupted? Did a setting get set somewhere that allows this?
What should I look for,
Thanks, JRAccording to the SQL Server 2000 Books Online
<tsqlref.chm::/ts_ra-rz_25rm.htm>, REPLACE is required only if both of
the following are true:
a. The database named in the RESTORE statement already exists on the
current server, and
b. The database name is different from the database name recorded in the
backup set.
Consequently, if the database name you backed up from is the same as the
target, the RESTORE will be allowed even without the REPLACE option.
Your server is not corrupted if this is the case in your situation.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"JR" <newsreader@.jmrcs.com> wrote in message
news:%23jjMpQ5TDHA.3188@.tk2msftngp13.phx.gbl...
> Hi everybody,
> I'm trying to figure out why my installation of SQL Server 2000 is
allowing
> databases to be restored that overwrite an exisitng databases, when I
do
> *not* specify the replace option.
> Is the server currupted? Did a setting get set somewhere that allows
this?
> What should I look for,
> Thanks, JR
>