Backing up Microsoft SQL Server databases

Before you begin

Before proceeding with a backup, ensure that there is enough free disk space to accommodate the backup file. The backup file size will be similar in size to the amount of storage used by the database. Verify the amount of available space can in the database properties (Size - Space available).

Running the backup

The report server is CAS and the default database name is CAS (or delta in older installations).

Stop the report server service.

Launch SQL Server Management Studio.
From the Start menu, select Start ► Programs ► Microsoft SQL Server 2008 ► SQL Server Management Studio.

Log in to the SQL Server Management Studio.
A login screen prompts for your user name and password.

In the Object Explorer, on the left side of the screen, select Databases and choose the database.
The default database names for NAM components are:

  • CAS
  • ADS
  • CVA for RUM Console

Right-click the report server database and choose Tasks ► Back Up.

On the General page, remove any existing backup destinations by clicking Remove.

Click Add to add a new backup destination.

Specify the path and name of the file for the database backup and click OK.

On the Options page, select Overwrite all existing backup sets.

Click OK to start the backup process.

The database will now be backed up.

After the backup is complete, restart the report server service.