• ALTER DATABASE db_name

    MODIFY FILE Secondary.ndf

    NAME = logical_file_name

    , OFFLINE

    http://msdn.microsoft.com/en-us/library/bb522469.aspx

    http://msdn.microsoft.com/en-us/library/ms191155.aspx

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”