1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

BACKUP DATABASE database_name TO DISK='d:\path\to\backup\file\on\the\server.bak'

1. 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. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.