Backup the iQSonar Database

Problem

Back up an iQSonar database.

To back up a database

After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.
Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
In the Database list box, seledt the iQSonar_Data database.
In the Backup type list box, select Full.
For Backup component, click Database.
Enter a different name for the backup set like: YYMMDD_company to insure you do not overwrite any of your standard backups.
Optionally, in the Description text box, enter a description of the backup set.
Set the backup to expire after 0 days
To view or select the advanced options, click Options in the Select a page pane.
Select an Overwrite Media option, by clicking one of the following:

And click Overwrite all existing backup sets.

SQL Server 2008 Enterprise and later supports backup compression. By default, whether a backup is compressed depends on the value of the backup-compression default server configuration option. However, regardless of the current server-level default, you can compress a backup by checking Compress backup, and you can prevent compression by checking Do not compress backup.