执行BACKUP DATABASE语句以创建完整的数据库备份，并指定:

要备份的数据库的名称.

写入完整数据库备份的备份设备.

完整数据库备份的基本Transact-SQL语法为:

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 databasename

TO backup_device [ ,...n ]

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

恢复

For restore

RESTORE DATABASE databasename

FROM Restore_device [ ,...n ];

例子

Example

BACKUP DATABASE MyDB TO DISK='C:/MyDBBackup.bak';
RESTORE DATABASE MyDB FROM DISK='C:/MyDBBackup.bak';

只需执行以下脚本即可在SqlConnection上备份数据库:

Just execute the following script to backup your database on SqlConnection:

BACKUP DATABASE [database name]
    TO DISK = 'c:\backup.bak'
    WITH NAME = 'Full Backup',FORMAT