Sangfor Community»Categories General Activity & Notice [Ended] Round 9 | Technical Document Scavenger Hunt

[Ended] Round 9 | Technical Document Scavenger Hunt

views: 131 | comments: 16 | added to Favorites 0
Lights on | 提示:支持键盘翻页<-左 右->
    组图打开中,请稍候......
Created: 2024-Nov-05 09:29

Summary:

Reply

pbeugenio Posted 2024-Nov-12 08:53
Q1: Use DMP in VPC Network Type if you need strict isolation, scalability, and are dealing with a multi-tenant environment or plan for a hybrid cloud model.
Use DMP in MCS if you prefer centralized management, simplified configuration, and are working with a single-tenant or smaller environment.

Q2: True

Q3: Full and Incremental

Q4: It is advised to use full backup plus incremental database backup and recovery
method to migrate the data in the existing SQL Server database to SQL Server database in DMP

Q5: Upgrade it to version 5.3.3_EN before upgrading to 5.4.0R2_EN
Q6: 5.4.0_EN
       5.4.0SP1_EN
       5.4.1_EN
       5.4.2_EN
       5.4.0R2_EN
ND Posted 2024-Nov-08 15:43
Q1:

Q2: True

Q3: full and incremental migration method

Q4: It is advised to use full backup plus incremental database backup and recovery method to migrate the data in the existing SQL Server database to SQL Server database in DMP, whether Single instance or SQL Server with Always on architecture.

Q5:  The version 5.1_EN cannot be directly upgraded to 5.4.0R2_EN and 5.4.5_EN. You are recommended to upgrade it to version 5.3.3_EN before upgrading.

Q6: 5.5.0R1_EN and 5.5.6_EN

Noviyanto Posted 2024-Nov-08 09:22
Q1 : There is no impact
Q2 : False
Q3 : SQL Server with a single instance on the customers on-premises cloud, and SQL Server Always On Database with one Standby
Q4 : Full backup plus incremental database backup and Recovery method
Q5 : It is recommended to upgrade it to version 5.3.3_EN before upgrading
Q6  Version 5.4.0_EN, 5.4.0SP1_EN. 5.4.1_EN. 5.4.2_EN. 5.4.0R2_EN
Newbie362074 Posted 2024-Nov-07 16:11
Q1: Shared service gateway required
Q2: True
Q3: Full recovery and incremental recovery
Q4: stop data access before last sync recovery
Q5: 5.1_EN to 5.4.2_EN to 5.4.5_EN
Q6: 5.4.0_EN to 5.4.2_EN
Dwi Nur Posted 2024-Nov-06 23:52
Q1: causing database restart and impact availability and stability of the service.
Q2: True
Q3: Full and Incremental database backup and recovery
Q4: Use full backup plus incremental database backup and recovery method
Q5: Upgrade it to version 5.3.3_EN first before upgrading to version 5.4.5_EN
Q6: 5.5.0R1_EN and 5.5.6_EN
Humayun Ahmed Posted 2024-Nov-06 18:35
Q1: Security: Both setups offer security, but VPC provides better isolation within a single cloud. MCS requires additional measures to secure data across multiple clouds.
Latency: VPC may provide lower latency than MCS due to fewer cross-cloud data transfers.
Scalability: Both environments are scalable, but MCS offers more flexibility for multi-cloud strategies.
Management Complexity: MCS introduces more complexity due to multi-cloud management, whereas VPC is more straightforward if limited to a single cloud provider.
Q2: True.
Q3: Full migration and incremental migration.
Q4: Full backup plus incremental database backup and recovery method.
Q5: The version 5.1_EN cannot be directly upgraded to 5.4.0R2_EN and 5.4.5_EN. You are recommended to upgrade it to version 5.3.3_EN before upgrading.
Q6: 5.5.6_EN
pmateus Posted 2024-Nov-06 17:58
Q1: No impact
Q2: True
Q3: Full and Incremental migration methods
Q4: Use full backup plus incremental database backup and recovery method.
Q5: The version 5.1_EN cannot be directly upgraded to 5.4.0R2_EN and 5.4.5_EN. You are recommended to upgrade it to version 5.3.3_EN before upgrading.
Q6: 5.4.0_EN, 5.4.0SP1_EN, 5.4.1_EN, 5.4.2_EN, 5.4.0R2_EN
ilham Posted 2024-Nov-06 15:37
Q1: -
Q2: True
Q3: full & incremental methods
Q4: it is advised to use full backup plus incremental database backup and
    recovery method to migrate the data in the existing SQL Server database
    to SQL Server database in DMP               
Q5: recommended to upgrade it to version 5.3.3_EN before upgrading
Q6: 5.5.0R1_EN & 5.5.6_EN
Clarence Roque Posted 2024-Nov-06 13:18
Q1: The impact of DMP in an on-premises cloud with a VPC network includes enhanced data control, privacy, and lower latency but requires more infrastructure management, while DMP in Managed Cloud Services (MCS) offers easier scalability, reduced maintenance, and cost-effectiveness, though with potentially less control over physical data location and slightly higher latency.
Q2: True.
Q3: Full and Incremental migration method.
Q4: , It is advised to use full backup plus incremental database backup and recovery method to migrate the data in the existing SQL Server database to SQL Server database in DMP.
Q5: The version 5.1_EN cannot be directly upgraded to 5.4.0R2_EN and 5.4.5_EN. You are recommended to upgrade it to version 5.3.3_EN before upgrading.
Q6: 5.5.0_EN can be upgraded to 5.5.0R1_EN, 5.5.6_EN, 5.9.0_EN, 5.9.1_EN and 5.4.5_EN can be upgraded to 5.5.0_EN, 5.50R1_EN, 5.5.6_EN.
Beru Posted 2024-Nov-06 12:02
Q1: causing database restart and impact availability and stability of the service

Q2 : true

Q3:
1. Backup and Recovery method
2. Detach and Attach method

Q4:
Align with the customer about the cut-off day and time
Send out a notice about the time for service stop
Ensure there is no access to the source database except for migration operation
Perform the last incremental backup and recovery to synchronize the data from source to target database
Disable database user access to prevent application or service access to the source database
Kill existing sessions manually

Q5 : upgrade from 5.1_EN to 5.3.8SP1_EN, and then from 5.3.8SP1_EN to 5.4.5_EN.

Q6 : 5.9.0_EN and 5.9.1_EN