Backing up a relational MR database
The procedure for backing up a database depends on the version of the SQL Server client tools that you are using.
To use Microsoft SQL Server to backup a database
1 Open SQL Server Management Studio.
2 In the Object Explorer pane, use the + symbol to expand the server on which your database is located.
3 Expand the Databases node.
4 Right click the database you want to backup, and then click Tasks > Backup
The Back Up Database dialog box opens.
5 In "Backup type", select Full.
6 Optional. To create the backup file in a location other than the default location, click Remove to delete the default location and then click Add to add a new location.
7 In the Back Up Database dialog box, click OK to run the backup.
Requirements
Microsoft SQL Server Client Tools
See also