Post reply

Can the Secondary files in a database be taken offline?

  • August 9, 2011 at 2:10 am

    #1365662

    Good question! I also want to recommend everyone to create one or more filegroup for user objects (like tables and indexes) and never place any user object in primary filegroup. If you separate the user objects from the system objects the database will be online even if you get a drive failure for the secondary filegroup (Enterprise feature).

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • December 21, 2020 at 7:32 am

    This was removed by the editor as SPAM

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply