Backing Up Prism Suite®, Policy Commander® and PwrSmart® SQL Databases

New Boundary Support
Install/Upgrade - General Information

The information in this article applies to Prism Suite versions 6 and later, all versions of Policy Commander, all versions of PwrSmart.

It is extremely important to regularly backup the databases associated with your New Boundary Technology products. This will allow you to recover from a hardware or software failure. Database backups should be done on a daily basis, and the resulting .bak files should be included in your nightly file backup.

The first section of this article shows how to back up SQL Server 2000 using SQL Enterprise Manager. The second section shows the command-line steps for backing up MSDE (SQL Desktop Engine). 

For a much more complete discussion of database backups, please refer to Microsoft SQL “Books Online” in the Related External Links section at the end of this article.

Backing up SQL Server using SQL Enterprise Manager or SQL 2005 Management Studio Express. (Screenshots show SQL Enterprise Manager.)

  1. Prism Channel databases are identified by the name of the Channel with “_PD” appended to the end. This article shows the steps for backing up a Channel named “Production.” Therefore, the channel database is named “Production_PD”. 

  2. Click the Add... button to add a destination for the backup.

  3. Give the backup a name and click OK. (Make sure that the location and folder structure already exist.)
  4. Click OK on the screen from step 2 to start the backup.
  5. Repeat steps 1 through 4 for all your Channel databases.

Backing up MSDE using OSQL Commands

MSDE doesn’t have a full set of GUI-based utilities like SQL Server does, but it does have command-line options for accomplishing database backup.

1.      On your MSDE server, open a DOS Window.

2.      Type the following:   osql –S %computername%\sw_deploy_server –E

3.      Within osql type:

1>BACKUP DATABASE Production_PD TO DISK = 'C:\Production_PD.bak'

2> GO <enter>

Note:  These steps assume that you are using the default MSDE instance that is created via the Prism Deploy or Prism Suite installation. If you manually installed MSDE or SQL Server before installing Prism, replace %computername%\sw_deploy_server with the name of the instance that you are using.

Note:  If backing up a database that contains dashes (-) such as the Quick Start Channel database, "Prism_Deploy_Sample_{GUID}", place the database name in brackets []. For example: 


BACKUP DATABASE [Prism_Deploy_Sample_12345678-1234-1234-1234-123456789] TO DISK = 'C:\Sample_PD.bak'

Also In This Category

On a scale of 1-5, please rate the helpfulness of this article

Not Helpful
Very Helpful
Optionally provide your comments to help us improve this article...

Thank you for your feedback!

Add Your Comments
Email Address:
RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
Toolbar's wrapper  
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.
Verification Code:
Last Modified: 12 Years Ago
Last Modified By: New Boundary Support
Article not rated yet.
Article has been viewed 10.6K times.
Customer Support Software By InstantKB 2015-2
Execution: 0.000. 8 queries. Compression Disabled.