Consider a scenario where a batch load of customer data into Azure SQL Database fails due to a schema mismatch. Outline the steps you would take to handle this failure, including how you would diagnose the issue, rectify the schema mismatch, and ensure the data load resumes without data loss.