Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backup SQL Server while in use?
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01541831
Message ID:
01541838
Vues:
39
>Thank you.
>
>>No
>>>
>>>When I need to do some changes to the customer database (SQL Server) I usually make a backup first using SSMS -> Tasks -> Backup. But the database could be used by some users ( VFP 9 application). Can creating this backup while the application may be accessing it, cause data corruption or another kind of a problem? TIA.

The opposite is not true - you should not have any connections to the database while making a restore. But for the backup you it does not matter.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform