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.