例7-1   BACKUP DATABASE 實例數據庫
        TO DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
        \實例數據庫.bak’
        WITH FORMAT


例7-2   restore database 實例數據庫
        from 實例數據庫.bak



分離數據庫： USE master
              GO
             sp_detach_db '實例數據庫'




附加數據庫   CREATE DATABASE 實例數據庫
             ON (FILENAME='D:\Program Files\Microsoft SQL Server\
             MSSQL.1\MSSQL\Data\實例數據庫.mdf')
               FOR ATTACH