Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup SQL Server while in use?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01541831
Message ID:
01541838
Views:
38
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform