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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment