Backup Microsoft SQL Server Objects dialog box

Use this dialog box to back up SQL Server database objects.

Note:

Partial backups and backups of read-write filegroups are not supported if you have SQL Express. SQL Server Express Edition has limited support for recovering from these backup types.

The following table describes how to use this dialog box:

What can I do from this dialog box?	Start a backup operation View the properties of the objects you selected for backup

Field descriptions	Backup Microsoft SQL Server Objects field descriptions

Procedures	Backing up databases Backing up transaction logs Backing up database filegroups Backing up read-only filegroups (SQL Server 2005 or later) Backing up read-write filegroups (SQL Server 2005 or later) Backing up database files Performing partial backups (SQL Server 2005 or later)

Related topics	Backing up and restoring the databases that contain full-text search catalogs (SQL Server 2005 or later) Performing backups and restores of remote SQL Server installations Performing a backup on a virtual SQL Server instance Using SQL Server in a cluster with a multi-interface network connection (multi-NIC) Performing SQL Server snapshot backups About backups and restores in an SAP environment