Database Backup

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

NOTE

This utility cannot be worked outside of the native folder.

We have shipped a utility with the Syncfusion Report Server application and it can be found in the below location.

{Windows_Drive}\Syncfusion\Report Server\Utilities\ReportServerBackup

This utility can take both the resources and database backups for the below types of Databases.

1. SQL CE
2. SQL Server

This utility can take only the resources backup for the below types of Databases.

1. MySQL
2. Oracle
3. PostgreSQL

Embedded SQL CE (For Testing purposes only)

Backup utility layout for Embedded SQL CE database.

On clicking the Backup Resources and Database button, backup is created and success message is displayed.

Created backup is stored as zip file in deployed folder as below.

{Windows_Drive}\Syncfusion\Report Server\ReportServer.Web\Backup

Created zip files’ contents are as like below,

SQL Server

Backup utility layout for SQL Server database.

On clicking the Backup Resources and Database button, backup is created and success message is displayed.

Backup of resources is stored as zip file in deployed folder as below,

Created zip files’ contents are as like below,

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

MySQL

Backup utility layout for MySQL database.

On clicking the Backup Resources button, backup is created and success message is displayed.

Backup of resources is stored as zip file in deployed folder.

Created zip files’ contents are as like below,

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

Oracle

Backup utility layout for Oracle database.

On clicking the Backup Resources button, backup is created and success message is displayed.

Backup of resources is stored as zip file in deployed folder.

Created zip files’ contents are as like below,

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

PostgreSQL

Backup utility layout for PostgreSQL database.

On clicking the Backup Resources button, backup is created and success message is displayed.

Backup of resources is stored as zip file in deployed folder.

Created zip files’ contents are as like below,

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

Help Link

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