Step 12 - Create database backups

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

This step explains how to backup the SQL databases. There are three databases that will be backed up as part of this step.

To create the DBBackup Folder

1. Log on to SQL1.fabrikam.com as Administrator

2. Click Start, click Computer, and then double-click Local Disk (C:).

3. Click File, point to New, and then click Folder.

4. Type DBBackup for the new folder, and then press ENTER.

To back up the DRMS_Config_rms_fabrikam_com_443 database

1. Log on to SQL1.fabrikam.com as 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 SQL1 and that Authentication is set to Windows Authentication. Click Connect.

   

3. On the right, expand Databases. Right-click DRMS_Config_rms_fabrikam_com_443, select Tasks and choose Back Up. This will bring up the Back Up Database – DRMS_Config_rms_fabrikam_com_443 windows.

   

4. From Back Up Database – DRMS_Config_rms_fabrikam_com_443, down under Destination, highlight the entry and click Remove. Click Add. This will bring up the Select Backup Destination box.

5. Click the … box. This will bring up the Locate Database Files – SQL1 window. Navigate to the folder that was created above. Enter DRMS_Config for the File Name and click OK.

   

6. On the Select Backup Destination screen, click OK.

   

7. On the Back Up Database – DRMS_Config_rms_fabrikam_com_443 screen, click OK.

   

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

   

To back up the DRMS_DirectoryServices_rms_fabrikam_com_443 database

1. Log on to SQL1.fabrikam.com as 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 SQL1 and that Authentication is set to Windows Authentication. Click Connect.

3. On the right, expand Databases. Right-click DRMS_DirectoryServices_rms_fabrikam_com_443, select Tasks and choose Back Up. This will bring up the Back Up Database – DRMS_DirectoryServices_rms_fabrikam_com_443 windows.

4. From Back Up Database – DRMS_DirectoryServices_rms_fabrikam_com_443, down under Destination, highlight the entry and click Remove. Click Add. This will bring up the Select Backup Destination box.

5. Click the … box. This will bring up the Locate Database Files – SQL1 window. Navigate to the folder that was created above. Enter DRMS_Directory for the File Name and click OK.

6. On the Select Backup Destination screen, click OK.

7. On the Back Up Database – DRMS_DirectoryServices_rms_fabrikam_com_443 screen, click OK.

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

To back up the DRMS_Logging_rms_fabrikam_com_443 database

1. Log on to SQL1.fabrikam.com as 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 SQL1 and that Authentication is set to Windows Authentication. Click Connect.

3. On the right, expand Databases. Right-click DRMS_Logging_rms_fabrikam_com_443, select Tasks and choose Back Up. This will bring up the Back Up Database – DRMS_Logging_rms_fabrikam_com_443 windows.

4. From Back Up Database – DRMS_Logging_rms_fabrikam_com_443, down under Destination, highlight the entry and click Remove. Click Add. This will bring up the Select Backup Destination box.

5. Click the … box. This will bring up the Locate Database Files – SQL1 window. Navigate to the folder that was created above. Enter DRMS_Logging for the File Name and click OK.

6. On the Select Backup Destination screen, click OK.

7. On the Back Up Database – DRMS_Logging_rms_fabrikam_com_443 screen, click OK.

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