Restore
To restore the file /backups/SQLServer/MM.bak into the Talend Data Catalog repository database MM use the following commands:
USE [master]
GO
ALTER DATABASE MM SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE [MM] FROM DISK = N'/backups/SQLServer/MM.bak' WITH REPLACE
GO
You may refer to the Microsoft SQL Server backup and restore documentation for more details on the above commands.