Explore BrainMass
Share

Explore BrainMass

    SQL Server 2000 Databases Management

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. What is the difference between complete and differential backups?

    2. Explain the meaning of each of the transaction levels supported by SQL Server.

    3. Explain the difference among the simple, full, and bulk-logged recovery models.

    4. What is the difference between clustered and nonclustered indexes?

    5. What triggers does SQL Server support?

    © BrainMass Inc. brainmass.com October 9, 2019, 6:16 pm ad1c9bdddf
    https://brainmass.com/computer-science/data-clustering/sql-server-databases-management-83386

    Solution Preview

    1. What is the difference between complete and differential backups?

    A complete backup makes a copy of the entire database. A differential backup makes a copy of the changes that have been made to the database since the last complete backup. A complete backup must be made before the first differential backup. Because differential backups are faster, they can be taken more frequently and the chance of data loss is reduced. Complete backups take longer but are slightly simpler to use for recovery.

    2. Explain the meaning of each of ...

    Solution Summary

    Database Management is highlighted. The difference between complete and differential backups are determined.

    $2.19