How to Create Full SQL Database backup commands

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Execute the BACKUP DATABASE statement to create the full database backup, specifying:

* The name of the database to back up.

* The backup device where the full database backup is written.

The basic Transact-SQL syntax for a full database backup is:

BACKUP DATABASE database

TO backup_device [ ,...n ]

[ WITH with_options [ ,...o ] ] ;

Option Description

database

Is the database that is to be backed up.

backup_device [ ,...n ]

Specifies a list of from 1 to 64 backup devices to use for the backup operation. You can specify a

physical backup device, or you can specify a corresponding logical backup device, if already

defined. To specify a physical backup device, use the DISK or TAPE option:

{ DISK | TAPE } =physical_backup_device_name

For more information, see Backup Devices.

WITH with_options [ ,...o ]

Optionally, specifies one or more additional options, o. For information about some of the basic

with options, see step 2.

2.

Optionally, specify one or more WITH options. A few basic WITH options are described here. For

information about all the WITH options, see BACKUP (Transact-SQL).

* Basic backup set WITH options:

{ COMPRESSION | NO_COMPRESSION }

In SQL Server 2008 Enterprise and later only, specifies whether backup compression is performed

on this backup, overriding the server-level default.

Get Oracle Certifications for all Exams
Free Online Exams.com