Originally posted on: http://geekswithblogs.net/AbhishekLohani/archive/2013/10/29/point-to-taken-care-while-sql-patching-testing--in.aspx

Point to Taken Care while Microsoft SQL Patching Testing in Production

It very critical testing like Paching testing

1. Build the Test Environment Parrel to Production Environment i.e Staging Environment

2 Check the Version of Application deployed is same as Production Environment if Staging Environment not parrel to production environment then risk of defect in production

3.Check End to End Flow of Appliction

4 Check the Eventlog entries

5 Check the performance of the Application .

Thanks & Regards

Abhishek