Search results

Database Backup

This section explains how to back up your resources and databases of the Report Server.

This utility cannot be worked outside of the native folder.

The Report Server is shipped with a utility to take backup of resources, and it can be find in the following location. {Installed_location}\Syncfusion\Report Server\Utilities\ReportServerBackup

Backup utility folder location

This utility can take both the resources and database backups for the following types of databases:

  • SQL CE
  • SQL Server

This utility can take only the resources backup for the following types of databases:

  • MySQL
  • Oracle
  • PostgreSQL

Embedded SQL CE (for testing purposes only)

Backup utility layout for the Embedded SQL CE database. Backup utility for SQL CE

On clicking the Backup Resources and Database, a backup is created and success message is displayed. SQL CE success message

The created backup is stored as a zip file in the installation folder. SQL CE backup folder

The created zip files’ contents are as in the following. SQL CE backup content

SQL Server

Backup utility layout for the SQL Server database. Backup utility for SQL Server

On clicking Backup Resources and Database, a backup is created and success message is displayed. SQL Server backup success

The backup of resources is stored as a zip file in the installation folder. SQL Server backup folder

The created zip files’ contents are as follows. SQL Server backup contents

The backup of database is stored as a .bak file in C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER2012\MSSQL\Backup

SQL Server database backup location

MySQL

Backup utility layout for the MySQL database. Backup utility for MySQL

On clicking Backup Resources, a backup is created and success message is displayed. Backup Utility MySQL Success

The backup of resources is stored as a zip file in the installation folder. Backup Utility MySQL Folder

The created zip files’ contents are as follows. Backup Utility MySQL Content

Database backup can be taken by following the procedure given in the mentioned link in utility.

Oracle

Backup utility layout for the Oracle database. Backup utility for Oracle

On clicking Backup Resources, a backup is created and success message is displayed. Oracle backup success

The backup of resources is stored as a zip file in the installation folder. Oracle backup folder

The created zip files’ contents are as follows. Backup Utility Oracle Content

Database backup can be taken by following the procedure given in the mentioned link in utility.

PostgreSQL

Backup utility layout for the PostgreSQL database. Backup Utility for PostgreSQL

On clicking Backup Resources, a backup is created and success message is displayed. PostgreSQL backup success

The backup of resources is stored as a zip file in the installation folder. PostgreSQL backup folder

The created zip files’ contents are as follows. PostgreSQL backup content

Database backup can be taken by following the procedure given in the mentioned link in utility.

UG documentation help link is provided at the title bar of the utility for all the database types. Backup utility Help link