Gordon Watt

<div>
Thank you for your help with this problem.<br />
<br />
Regards<br />
<br />
GW
</div>


Thank you for your help with this problem.

Regards

GW

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Hope someone can help me with an issue we are having with our SQL Server running on VMware.<br />
<br />
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.<br />
<br />
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.<br />
<br />
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.<br />
<br />
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.<br />
<br />
Regards<br />
<br />
GW<a href="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396510/sql-server-error.JPG" target="_blank" title="sql-server-error.JPG (66 KB)"><img alt="sql-server-error.JPG" class="file-block lazyload" style="max-width: 640px;" data-src="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396510/sql-server-error.JPG" /></a>
</div>
</div>


sql-server-error.JPG

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

In VMware, how do you get snapshot to work, without disconnecting database users?

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.

VMware

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.