sql2008常用语句

    附加：
    use master

    go

    sp_attach_db 'XX',

    'E:\Program Files\Microsoft SQL Server\MSSQL10_50.WZSSQL2008R2\MSSQL\DATA\XX.mdf',

    'E:\Program Files\Microsoft SQL Server\MSSQL10_50.WZSSQL2008R2\MSSQL\DATA\XX.ldf'

    GO

    分离：
    use master

    go

    sp_detach_db 'XX'

    go

    还原：
    */
    USE master
    RESTORE DATABASE sl
    FROM DISK = 'D:\xxx.bak'
    WITH REPLACE,
    MOVE 'xxx_Data' TO 'D:\xxx.MDF',
    MOVE 'xxx_Log' TO 'D:\xxx.LDF',
    STATS = 10

    GO