troubleshooting Question
In VMware, how do you get snapshot to work, without disconnecting database users?
Gordon Watt asked on
Hi,
Hope someone can help me with an issue we are having with our SQL Server running on VMware.
We have a server box, which is running VMware Workstation 14. The operating system is Windows server 2016, and the virtual server also has SQL Server 2017 running on it.
We have used VMware for another server in the past and not had any problems with doing snapshots, however when we scheduled snapshots to run every hour, anyone connected to the SQL Server and its databases, were presented with the attached error message on the screens.
From the research I've done so far, I believe that the snapshot function is disconnecting all the existing SQL Server connections and preventing any new connections during the time that the snapshot is running.
Can someone please explain if it is possible to have snapshot function in VMware along with the SQL Server, so that when staff are entering records into the database, snapshot can still run an hourly backup to keep things up-to-date.
Regards
GW![sql-server-error.JPG]()
Hope someone can help me with an issue we are having with our SQL Server running on VMware.
We have a server box, which is running VMware Workstation 14. The operating system is Windows server 2016, and the virtual server also has SQL Server 2017 running on it.
We have used VMware for another server in the past and not had any problems with doing snapshots, however when we scheduled snapshots to run every hour, anyone connected to the SQL Server and its databases, were presented with the attached error message on the screens.
From the research I've done so far, I believe that the snapshot function is disconnecting all the existing SQL Server connections and preventing any new connections during the time that the snapshot is running.
Can someone please explain if it is possible to have snapshot function in VMware along with the SQL Server, so that when staff are entering records into the database, snapshot can still run an hourly backup to keep things up-to-date.
Regards
GW
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Fellow title is reserved for select members who demonstrate sustained contributions, industry leadership, and outstanding performance. We will announce the experts being inducted into the Experts Exchange Fellowship during the annual Expert Awards, but unlike other awards, Fellow is a lifelong status. This title may not be given every year if there are no obvious candidates.
The Expert of the Year award recognizes an expert who helped improve Experts Exchange in the past year through high levels of contributions and participation on site. This award is given to the expert who has achieved the highest levels of participation, while maintaining quality contributions and professionalism.