Backup/Restore 命令

备份数据库到文件

BACKUP DATABASE database_name TO DISK = 'database.bak'

从文件还原为数据库

RESTORE DATABASE database_name FROM DISK = 'database.bak'