We use VMware Vsphere 6.7 and have an application that runs on SQL database and unfortunately, we have problems with this database server.
I have been asked by the application vendor to run some patches and detach the database and again attach the database.
Rather than running these patches on the actual server, I thought of cloning the SQL server and run the patches and detach and attach the database on the cloned server and if the issue gets resolved, I can shut down the old server.
As it is Sunday today, no one will be using the server.
Do I need to clone or snapshot?
Also, do I need to do this while the server is powered on or in a shutdown state?
Please suggest appropriate steps and thank in advance.
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>