Last modified by Phillip Swanepoel on 2026/06/09 12:46
<
From version < 15.1
edited by Phillip Swanepoel
on 2026/06/09 12:46
To version < 9.2 >
edited by Phillip Swanepoel
on 2025/03/17 13:03
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -7,7 +7,7 @@
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 -- [[image:image-20250411144502-1.png||height="150" width="284"]]
10 +
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
... ... @@ -22,15 +22,10 @@
22 22  11. recreate tblDocuments synonym
23 23  11. tblAudit if applicable
24 24  
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 +1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
26 26  11. correct all config found and repoint to Staging
27 27  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
31 -11. Use [[doc_central.sql - Repos>>url:https://dev.azure.com/ebsphere/ebsphere/_git/devops?version=GBmaster&path=%2Fsetup-scripts%2Fdoc_central.sql]] to update staging documents when restoring from live.
32 32  1. Start all services
33 33  11. check logs to make sure no connections issues
34 -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
35 35  
36 36  
image-20250411144502-1.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.nikhils
Size
... ... @@ -1,1 +1,0 @@
1 -67.7 KB
Content

Applications

Navigation

Need help?

If you need help with XWiki you can contact: