备份还原数据库

备份:
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为数据库名