备份:

BACKUP DATABASE "mydb" TO DISK ='C:\backupdatabase .bak' with init

还原
use master
RESTORE DATABASE "mydb" FROM DISK='C:\backupdatabase.bak'  ';
use mydb