Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A better way
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
Divers
Thread ID:
00489167
Message ID:
00489474
Vues:
11
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform