Backing Up Your SQL Server Database

SQL Server Management Studio contains a native backup tool that can be used to back up your Laserfiche database. Click here for more options on backing up your database.

To back up a database using SQL Server Management Studio

1. Open SQL Server Management Studio.
2. Connect to the SQL server used by Laserfiche.
3. Click the server name to expand the server tree.
4. Expand the Databases item and right-click the database used by Laserfiche.
5. Select Tasks and Back Up.
6. In the Backup type option, select one of the following:
   
• Full. This will perform a full backup of the data in the database. It is recommended that you perform a full backup at least once weekly.
• Differential. This will perform a backup only of data that has changed since the last full database backup. It is recommended that you perform a differential backup daily, or more often for very high-volume repositories.
7. In the Backup component option, select Database.
8. Choose the type of backup destination by selecting Disk or URL.
9. Click the Add button and select the destination for the backup file.
10. Optional: Navigate to the Backup Options page. Change the Name and Description of the backup if desired.
11. On the Backup Options page, specify when the backup will expire:
• To configure the backup to expire after a specific number of days, click After and enter the number of days. Entering zero (0) configures the backup to never expire.
• To configure the backup to expire on a specific date, click On and enter a date.
12. Optional: To view or select advanced options about how media is overwritten or how the backup is verified, navigate to the Media Options page.
13. When you have finished configuring the backup, click OK to start the backup process.