>Wayne,
>
>Thanks for the input. The replace option is: "Force restore over existing database"?
>
>tv
yes
>
>>>I need to receive database backups from clients and replace mine with them. I wonder if there is a better way than to delete my database and then restore theirs in, in case they send me something bad or etc.
>>>
>>>I don't like to change my connections.
>>>
>>>Would incremental backups be the solution?
>>>
>>>I wish I could just rename the current database temporarily, restore new and then delete old.
>>>
>>>Thanks
>>
>>If you use the REPLACE option for RESTORE, you can overwrite your database... so the scenario you could use would be to backup your current copy, replace the copy with your clients, then discard the backup if everything goes Ok.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown