Backing up and restoring a database on Microsoft SQL Server - 7.3

Talend Data Catalog Installation and Upgrade Guide for Windows

author
Talend Documentation Team
EnrichVersion
7.3
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Installation and Upgrade
EnrichPlatform
Talend Data Catalog
Back up or restore your SQL Server database using SQL Server Management Studio (SSMS).
  • You have created a directory on your server machine to store all the exported files, such as .bak files.
  • You have launched SQL Server Management Studio and started your SQL Server instance.
  • You have stopped Talend Data Catalog application server before performing the backup and restore tasks.

Backing up using SSMS

  1. Open a New Query window.
  2. Execute the following Transact-SQL (T-SQL) command to backup your SQL Server database into a file:
    BACKUP DATABASE [<db_name>] 
    TO DISK = N'<backup_directory_path>\<bak_file_name>' 
    WITH 
    NAME = N'<db_name>-Full Database Backup'
    GO

Restoring using SSMS

  1. Open a New Query window.
  2. Execute the following T-SQL command to restore the file into the database server:
    USE [master]
    GO
    ALTER DATABASE <db_name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    GO
    RESTORE DATABASE [<db_name>] 
    FROM DISK = N'<backup_directory_path>\<bak_file_name>' WITH REPLACE
    GO
  3. Restart Talend Data Catalog application server.
  4. To ensure the optimal Talend Data Catalog application server performance, go to MANAGE > Schedules to run the database maintenance script.
  5. Right-click Run Database Maintenance and click Run operation now to update the database indexes and statistics.

You can also use the SQL Server Management Studio Object Explorer UI. For more information, refer to the Microsoft SQL Server backup and restore documentation.