This may be done either using Microsoft SQL Server or in RMS. Please refer to SQL Server's documentation if you wish to back up the RMS database using its features.
Step by step instructions:
1. From the Home window, expand the Data Management branch and double-click on the Scheduler branch.
2. Click the New button.
3. Select Backup Database from the Activity text box drop down list; select the date and time for the first backup; select the Interval (Daily is recommended); click the Save and Close button.
You may also backup the RMS database manually, although it is best to schedule an automatic backup to ensure that this important process is not forgotten. Follow these steps for a manual backup:
1. Click on the Data Management | Backup and Restore Database menu.
2. Select the Backup radio button and click OK.
Note: Database backup files are stored in the RMS Flat File Directory. By default, backup files for the last 7 days are kept. If more than one backup is done on the same day, that previous backup file is overwritten.
Note for single users who have installed the RMS Data Engine (SQL Server 2005 Express) on their computer and wish for the database backups to be stored on a shared folder on a remote network server.
SQL Server 2005 Express runs as a service and it logs on by default as a Local System account. This limits its activities to the local system. However, you can change the account that the SQL Service logs in as to a regular user account that has permissions to a remote share. You will need to do one other thing, mapped drives won't work, you need to use a UNC. Here is what you need to do:
Note: running the SQL Server service with a specific user account is approved and recommended by Microsoft.
1. Open Services from the Windows Control Panel | Administrative Tools.
2. Find the SQL Server (SQLExpress) service and open Properties by right clicking on the entry and clicking Properties.
3. Click on the Log On tab and change it to log on with the specific user account that has access to the remote share. Ideally, this is the user account that runs the RMSAgent scheduled task too (see Schedule RMS to run automatically topic). Enter the password for this account (note you will need to remember to change the password here if it ever changes). Be sure that this user account has full access to the folder that you will be using for the backups.
4. Click OK (Note: you may need to stop and start the service for the change to take effect.
5. In RMS, click on Data Mgmt | Reference Values and select Flat File Directory from the QuickFind. This is where the database backup is going to go. Be sure that you have a UNC (universal naming convention) for the path in the Value text box. For example: \\myservername\mysharename. Mapped drives will not work for this process.