Deployment Best Practice

If the script contains Delete or Update

1.      Retrieve the output of the data which will be modified or delete action required to be taken, Copy the Retrieved data, validate and confirm with production data by using Excel sheet.

2.      Before Delete or Modify action, Ensure Copy only backup available in the Current Incident/Change order Folder.

3.       Must follow Try/catch command on Delete / Modify operation.

If the Script contains read the data from the SQL Server.

1.      Please provide the actual Execution plan from the UAT Environment.

2.      Please list the IO and time Statistics Information.