Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Step 12 - Create database backups

Updated: March 19, 2013

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.

  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.

Database backup folder

  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.

    SQL Server Login

  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.

    Backup DRMS_Config

  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.

    Backup DRMS_Config

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

    Backup DRMS_Config

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

    Backup DRMS_Config

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

    Backup DRMS_Config

  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.

  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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.