Step 13 - Restore the Database to the New SQL Server

  • Article

Applies To: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012

This step explains how restore the databases that were backed up from SQL1 in the last step.

To copy the databases over to SQL2

  1. Log on to SQL2.fabrikam.com as fabrikam\Administrator

  2. Click Start, select Run and enter \\SQL1\C$ in the box. Click OK.

  3. Navigate to C:\DBBackup on SQL1. Copy the entire folder to C:\DBBackup on SQL2.

  4. When the copy is complete you can close the SQL1\C$ window.

To restore the DRMS_Config_rms_fabriakam_com_443 databases from SQL1

  1. Log on to SQL2.fabrikam.com as fabrikam\Administrator.

  2. Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio. This will bring up the Connect to Server dialog box. Ensure that the Server name is SQL2 and that Authentication is set to Windows Authentication. Click Connect.

  3. On the right, right-click Databases and select Restore Database. This will bring up the Restore Database window.

  4. On the Restore Database screen, select the From Device radio button and click the … box. This will bring up the Specify Backup screen.

  5. On the Specify Backup screen, click Add. This will bring up the Locate Backup File – SQL2 screen.

    Select the DBBackup folder. Enter DRMS_Config for the File Name and click OK.

  6. On the Specify Backup screen click OK.

  7. On the Restore Database screen, in the drop-down next to To database: select DRMS_Config_rms_fabrikam_com_443.

  8. On the Restore Database screen, under Select the backup sets to restore: place a check in the Restore box, next to DRMS_Config_rms_fabrikam_com_443-Full Database Backup. Click OK.

  9. Once this has completed, a pop-up will say the database has been restored successfully. Click OK.

To restore the DRMS_DirectoryServices_rms_fabriakam_com_443 databases from SQL1

  1. Log on to SQL2.fabrikam.com as fabrikam\Administrator.

  2. Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio. This will bring up the Connect to Server dialog box. Ensure that the Server name is SQL2 and that Authentication is set to Windows Authentication. Click Connect.

  3. On the right, right-click Databases and select Restore Database. This will bring up the Restore Database window.

  4. On the Restore Database screen, select the From Device radio button and click the … box. This will bring up the Specify Backup screen.

  5. On the Specify Backup screen, click Add. This will bring up the Locate Backup File – SQL2 screen. Select the DBBackup folder. Enter DRMS_Directory for the File Name and click OK.

  6. On the Specify Backup screen click OK.

  7. On the Restore Database screen, in the drop-down next to To database: select DRMS_DirectoryServices_rms_fabrikam_com_443.

  8. On the Restore Database screen, under Select the backup sets to restore: place a check in the Restore box, next to DRMS_DirectoryServices_rms_fabrikam_com_443-Full Database Backup. Click OK.

  9. Once this has completed, a pop-up will say the database has been restored successfully. Click OK.

To restore the DRMS_Logging_rms_fabriakam_com_443 databases from SQL1

  1. Log on to SQL2.fabrikam.com as fabrikam\Administrator.

  2. Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio. This will bring up the Connect to Server dialog box. Ensure that the Server name is SQL2 and that Authentication is set to Windows Authentication. Click Connect.

  3. On the right, right-click Databases and select Restore Database. This will bring up the Restore Database window.

  4. On the Restore Database screen, select the From Device radio button and click the … box. This will bring up the Specify Backup screen.

  5. On the Specify Backup screen, click Add. This will bring up the Locate Backup File – SQL2 screen. Select the DBBackup folder. Enter DRMS_Logging for the File Name and click OK.

  6. On the Specify Backup screen click OK.

  7. On the Restore Database screen, in the drop-down next to To database: select DRMS_Logging_rms_fabrikam_com_443.

  8. On the Restore Database screen, under Select the backup sets to restore: place a check in the Restore box, next to DRMS_Logging_rms_fabrikam_com_443-Full Database Backup. Click OK.

  9. Once this has completed, a pop-up will say the database has been restored successfully. Click OK.