| Check
list for Go-Live |
||
| S.No | Item's | Assigned to |
| Pre-Check | ||
| 1 | Get latest full backup file location and name of database. And Ticket number. | On premise Team |
| 2 | Copy backup file share path to into local drive in the DB server. | SQL DBA |
| 3 | Script out all Logins and permission. | SQL DBA |
| 4 | Script out all Users and permission. | SQL DBA |
| 5 | Script out the Linked server. | SQL DBA |
| 6 | Script out the Application jobs. | SQL DBA |
| 7 | Note the dependent folder permission for Service account. | SQL DBA |
| 8 | Break Log shipping on Primary server. | SQL DBA |
| 9 | Break Log shipping on Secondary server. | SQL DBA |
| Configuration | ||
| 10 | Take latest database full backups of all databases on Primary server | |
| 11 | Mute Datadog Monitoring to matrix for the maintenance window on Primary and DR server. | |
| 12 | Restore database with copied backup file. | SQL DBA |
| 13 | Run consistency check command | SQL DBA |
| 14 | Restore Orphan users | SQL DBA |
| 15 | Restore Logins | SQL DBA |
| 16 | Restore users | SQL DBA |
| 17 | Restore Linked server | SQL DBA |
| 18 | Restore Application job. | SQL DBA |
| 19 | Grant the dependent folder permission for Service account. | SQL DBA |
| 20 | Fetch Row Count in excel sheet to share with SB team. | SQL DBA |
| 21 | Apply same step 11 to 19 on 2ndary DR or 2ndary server. | SQL DBA |
| 22 | Configure the Log Shipping from Primary server to 2ndary server for all the restored Database. | SQL DBA |
| Post Check | ||
| 23 | Verify and confirm Database status. | SQL DBA |
| 24 | Verify and confirm Login created. | SQL DBA |
| 25 | Verify and confirm Users created. | SQL DBA |
| 26 | Verify and confirm Orphan users. | SQL DBA |
| 27 | Verify and test Linked Servers. | SQL DBA |
| 28 | Verify the Application jobs. | SQL DBA |
| 29 | Verify the folder permission for Service account. | SQL DBA |
| 30 | Run the Application job and mark the result. | SQL DBA |
| 31 | Share the Row count the with SB team. | SQL DBA |
| 32 | Verify the Log shipping jobs and status for all restored databases. | SQL DBA |
| 33 | Hand over DB Row count sheet and the server to SB team to test at their end. | SQL DBA |
| 34 | Verify DataDog Monitoring and maintenance jobs | SQL DBA |
| 35 | Get confirmation for SB team and close the ticket | On Premise Team & SQL DBA |
Thursday, 22 November 2018
Database refresh- Check list for Go-Live from On premise to AWS server
Labels:
Go-Live
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment