Home / CSE / Database System 2 - CS :: Discussion

Discussion :: Database System 2 - CS

  1. SQL Server supports three recovery modes: simple, full and Bulk.

  2. A.

     True

    B.

     False

    View Answer

    Workspace

    Answer : Option A

    Explanation :

    SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options.

    The three disaster recovery models offered by SQL Server are:
    1. Simple Recovery Model
    2. Full Recovery Model
    3. Bulk-logged Recovery Model


Be The First To Comment