Pre and Post SQL Server health checks for P2V conversion

Question

I would like to know what would will be typical SQL Server health checks performed before and after a P2V conversion ? I have a requirement and what I planned is

Pre conversion - Health checks

• Backup databases
• Check SQL and Windows Logs to make sure there are issues

Post conversion - Health checks

• Check SQL Services have started successfully
• Check SQL and Windows Logs
• Perform Database integrity checks

I would like to know what typical checks other DBA's perform ?

---

Don

Answer 1

Hi Don,

I think your plan is applicable and for P2V conversion, the process is more important.

We need to pay more attention to the requirements for both source machine and destination machine. Different conversion types have different processes (offline or online convert). 

Please refer to these references before you perform the conversion:
http://technet.microsoft.com/en-us/library/cc917954.aspx
http://technet.microsoft.com/en-us/library/cc917882.aspx
http://technet.microsoft.com/en-us/library/cc764232.aspx

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

The P2V conversion is done by the Intel team. I need to do pre and post checks to make sure the SQL Server is running fine after conversion and in case something does go wrong, I have to be ready with action plan to restore/recover it working state.

---

Don

Answer 3

Please refer to the below link. It may help you.

http://www.brentozar.com/community/virtualization-best-practices/