Explore BrainMass
Share

SQL Server 2000 Databases Management

This content was STOLEN 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 24, 2018, 7:56 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
See Also This Related BrainMass Solution

Relational Database Management Systems

Using the Internet, research two of four commercial relational database management systems listed below:

Oracle 9i
DB2 Universal Database (IBM)
SQL Server 2000 (Microsoft)
Sybase Adaptive Server IQ Multiplex.

In 2 to 3 paragraphs, compare and contrast the features of both and choose which one you would use for your business and why. The objective is to recognize different styles of storing information in an organized manner and to describe the architecture of a RDBMS.

Be sure to cite your sources

View Full Posting Details