Share
Explore BrainMass

SQL Server 2000 Databases Management

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?

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.

$2.19