Last modified by Phillip Swanepoel on 2026/06/09 12:46
<
From version < 9.1 >
edited by Phillip Swanepoel
on 2025/03/17 12:42
To version < 14.1 >
edited by Nikhil Singh
on 2025/12/01 07:18
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.phillips
1 +XWiki.nikhils
Content
... ... @@ -7,12 +7,13 @@
7 7  11. drop existing connections
8 8  
9 9  1. Restore DB from Live from last PITR or latest Full backup if DB age is not important
10 -
10 +- [[image:image-20250411144502-1.png||height="150" width="284"]]
11 11  1. Give yourself access to the admin group via the powershell script - if needed
12 12  
13 13  1. Wait for group policy SQL JOB [roughly 5-10 minutes] to create groups
14 14  
15 15  1. Run post restore access script [[SKL_sqlmi_accesss.sql - Repos (azure.com)>>url:https://dev.azure.com/ebsphere/ebsphere/_git/dbs?version=GBmaster&path=/src/setup_scripts/SKL_sqlmi_accesss.sql]]
16 +11. This has to be run using SQLCMD mode on the script
16 16  11. [TODO] source passwords from vault
17 17  11. set clearLogins = 2
18 18  11. TODO
... ... @@ -21,10 +21,14 @@
21 21  11. recreate tblDocuments synonym
22 22  11. tblAudit if applicable
23 23  
24 -1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
25 +1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%' (exec dba.[dbo].[sp_scan_db] @includestr = '%DBC[_]Live%', @databasename = 'DBC_Live_Everest')
25 25  11. correct all config found and repoint to Staging
26 26  11. TODO automate (some of the config correcting statements can be generated using [dba].[devops].[sp_change_db_env_post_restore])
28 +11. exec dba.[devops].[sp_change_db_env_post_restore] @dbname = 'ENV_Staging_Everest', @ClientCode ='ENV', @Sourceenv = 'Live', @TargetEnv = 'Staging',
29 +@domainRev = 'com.site', @domain = 'site.com',@svcUserPass = 'xxx.xxx.xxx.xxx#xx'
30 +11. After executing the output of the dba.devops.sp_change_db_env_post_restore rerun this SP and make sure there is no objects that hasn't changed
27 27  1. Start all services
28 28  11. check logs to make sure no connections issues
33 +1. Log into the new DB with Everest and do a happyline test -> search for a member -> view member details -> upload a document -> download a document
29 29  
30 30  
image-20250411144502-1.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.nikhils
Size
... ... @@ -1,0 +1,1 @@
1 +67.7 KB
Content

Applications

Navigation

Need help?

If you need help with XWiki you can contact: