sql server 完全备份

--完全备份 
BACKUP   DATABASE   dbBackTest   
      TO   DISK   =   'd:\dbBackTest.bak ' 
with   PASSWORD= '123 ' 

--还原完整备份 
RESTORE   DATABASE   dbBackTest 
      FROM   disk= 'd:\dbBackTest.bak ' 
with   PASSWORD= '123 '