备份还原数据库

备份:
BACKUP DATABASE "aaa" TO DISK ='C:mybak.db' with init

还原
use master
RESTORE DATABASE "aaa" FROM DISK='D:mybak.db' WITH REPLACE;
use aaa

aaa为数据库名