Thursday 22 November 2018

Database refresh- Check list for Go-Live from On premise to AWS server



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

No comments:

Post a Comment