Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A better way
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Miscellaneous
Thread ID:
00489167
Message ID:
00489301
Views:
8
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform