Sample Header Ad - 728x90

What happens when SQL query is executing prior to snapshot backup and query executed during snapshot backup?

1 vote
1 answer
74 views
During vss based snapshot backup, databases IO is frozen one by one. And subsequently resumed. Questions: 1. When there is a query running, and vss based snapshot backup is executed, will the freeze get delayed (that is - wait for running query to complete)? 2. Assuming the freeze and resume interval is 60 seconds. What happens to user queries fired during this 60 seconds interval. Are they queued? Or rejected?
Asked by variable (3590 rep)
Oct 8, 2021, 04:39 AM
Last activity: Oct 8, 2021, 01:52 PM