Hi
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 >>
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.