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.