Skip to main content
pdf?stylesheet=default
Blackboard Help

Back Up the Database in a SQL Environment

If you are a Managed Hosting customer, this topic doesn't apply to you.
 

Back up the database using Microsoft SQL Server 2014 Backup/Restore Utility. Create a current SQL Server backup of all the Blackboard databases. If your institution licenses content management, you must back up additional databases along with the Blackboard Learn databases.


Blackboard Learn databases

  • BBLEARN_ADMIN
  • BBLEARN
  • BBLEARN_STATS

Blackboard Learn legacy databases

  • BBADMIN
  • BB_BB60
  • BB_BB60_STATS

Content management databases

  • BBLEARN_CMS
  • BBLEARN_CMS_DOC

Content management legacy databases

  • CMS
  • CMS_FILES_COURSES
  • CMS_FILES_INST
  • CMS_FILES_LIBRARY
  • CMS_FILES_ORG
  • CMS_FILES_USERS

Follow the abbreviated steps below to perform a full backup of all your Blackboard databases using the Microsoft SQL Server 2014 backup and restore utility. The backup of any data should be scheduled for a time when you can turn off access to the Blackboard website. Backup the file system at the same time to ensure a synchronized backup of both file system content and databases.


Stop the services

  1. Launch a command prompt from the Windows Start menu.
  2. Navigate to blackboard_home\tools\admin.
  3. Stop all services by typing the following command and pressing the ENTER key:

    servicecontroller.bat services.stop

More on Blackboard Services


Configure and initiate the backup

  1. Select Start > All Programs > Microsoft SQL Server 2014 > SQL Server Management Studio.
  2. Connect to the database and select the expanded Databases folder to expand the list of databases.
  3. Highlight the BBLEARN database and right-click on the selected database.
  4. Point to Tasks, and then select Back Up. The Back Up Database dialog box appears.
  5. In the Database drop-down list, verify the database name. Optionally, you can select a different database from the list.
  6. The Recovery model text box is for reference only. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE).
  7. In the Backup Type list box, select Full. For Backup component, select Database. The default setting is to perform a Full database backup and will append to any existing media if available. Accept the default setting for the backup.
  8. Optionally, you can select the Copy-only backup checkbox to create a copy-only backup. A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. For more information, see Copy-Only Backups (SQL Server).
  9. For Backup component, select Database.
  10. In the Destination section, use the Back up to drop-down list to select the backup destination. Select Add to add additional backup objects and/or destinations.
  11. To remove a backup destination, select it and select Remove. To view the contents of an existing backup destination, select it and select Contents.
  12. In the Destination section of the General page, select Disk or Tape. Choose the destination or location of the database backup files by selecting Add. The default location of backups in SQL is under SQL Server’s directory tree. To view or select the media options, select Media Options in the Select a page pane.

    Example:

    C:\All Programs\Microsoft SQL Server 2005\MSSQL\BACKUP\

    Blackboard recommends backing up your data to an alternate location. If there is a need to reinstall SQL Server the data files for your Blackboard application will be protected from accidental deletion during an SQL Server uninstall and reinstall.

    Example:

    D:\SQL\MSSQL\BACKUP\

    The remaining SQL backup steps will outline how to backup to a new Backup Device location.

  13. After selecting Add, under the Destination field, a new window opens showing the default location to store the backup. Do not accept the default location. Select Browse to find a new backup device location directory on the local server.
  14. Browse to the new directory location and highlight the new directory.
  15. Enter a name in the file name field at the bottom of the Destination for the backup files using the .bak as the extension. Adding the extension will allow SQL Server to recognize the file type for all your database backup files.

    Example:

    dates-12122016.bak for December 12, 2016 or names-BBLEARN.bak for one time backups

    Select the type of storage device the backup should be stored to, Disk or Tape.

  16. Select OK to accept the new device location and file name. Select OK again to close the Select Backup Destination window.
  17. From the Options page, under Reliability, select the Verify backup when finished button to complete the backup procedure.
  18. Select OK to start the database backup. The backup has completed when the message shows that the backup operation and verification completed successfully.
  19. Repeat the above steps for each Blackboard Learn and content management database.