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 ?
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:
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
2012年3月23日 14:16The 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.
Please refer to the below link. It may help you.