Database migration Details Steps For SCCM & Forefront Endpoint Protection 2010

Database migration Details Steps For SCCM & Forefront Endpoint Protection 2010

1.       Take snapshot of SCCM1 & FFEP2k10

2.       Download http://hotfixv4.microsoft.com/ConfigMgr%202007%20R3/nosp/SCCM_2007_R3_KB2676737_ENU/4.0.6561.1102/free/445834_ENU_i386_zip.exe

3.       Install above in SCCM1 for (SSRS does not work after you upgrade SQL Server to SQL Server 2012 in System Center Configuration Manager 2007 R3) remedy kept in E drive of SCCM1

4.       Create SPN for New SQL 2012

a.       Setspn –A MSSQLSvc/<FQDN of SQL 2012 server>:1443 account name (account will be “Domin Admin with schema change permission” and “DBA proposed”)

5.       Download http://hotfixv4.microsoft.com/Microsoft%20Forefront%20Endpoint%20Protection%202010%20Server/nosp/FEP_2010_SU1_KB2683558_ENU/02.01.1116.0108/free/445827_ENU_x64_zip.exe

6.       Install above in FFEP2k10 kept in Downloads folder of Admin

7.      

8.       Back up the site database on the current site database server and restore it on the new site database server computer using the SQL Server Management Studio.

9.       Ensure the primary site server computer account has administrative privileges over the new site database server computer.

10.   Close any open Configuration Manager console connections to the site server.

11.   On the primary site server computer, use the hierarchy maintenance tool (Preinst.exe) to stop all site services with the following command: Preinst /stopsite.

12.   On the primary site server computer, click Start, click All Programs, click Microsoft System Center, click Configuration Manager 2007, and click ConfigMgr Setup, or navigate to the .\bin\i386 directory of the Configuration Manager 2007 installation media and double-click Setup.exe.

13.   Click Next on the Configuration Manager Setup Wizard Welcome page.

14.   Click Perform site maintenance or reset this site on the Configuration Manager Setup Wizard Setup Options page.

15.   Select Modify SQL Server configuration on the Configuration Manager Setup Wizard Site Maintenance page.

16.   Enter the appropriate SQL Server name and instance (if applicable) for the new site database server as well as the site database name on the Configuration Manager Setup Wizard SQL Server Configuration page.

17.   Configuration Manager Setup performs the SQL Server configuration process.

18.   Restart the primary site server computer, and verify the site is functioning normally.

Move the FEP Databases and the CM Site Database

1.       Backing up the FEP data warehouse (FEPDW_<sitecode>)

2.       Backing up the Configuration Manager Site Database (SMS_<sitecode>)

3.       Uninstalling the FEP reporting component

4.       Restoring the site database and FEP data warehouse to their new locations

5.       Relocating the site database via Configuration Manager setup

6.       And then reinstalling the FEP Reporting component