Skip to content

To perform backup or restore log in to the SQL Server Management Studio, open a new query window and execute the backup or restore commands given below. You can also use the SQL Server Management Studio Object Explorer UI to perform the backup and restore tasks.

Backup

To backup the repository database MM into a file /backups/SQLServer/MM.bak, use the following command:

BACKUP DATABASE [MM] TO DISK = N'/backups/SQLServer/MM.bak' WITH NAME = N'MM-Full Database Backup' GO

Restore

To restore the file /backups/SQLServer/MM.bak into the MetaKarta 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.