Changes for page MI Restore to Staging From Live
Last modified by Phillip Swanepoel on 2026/06/09 12:46
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. phillips1 +XWiki.nikhils - Content
-
... ... @@ -22,11 +22,9 @@ 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 30 1. Start all services 31 31 11. check logs to make sure no connections issues 32 32