1.  Explain each of the four backup methods available in MSSQLS.  Be specific and provide detail for each one.


Explain in detail the MSSQLS recovery models.  Be detailed and provide specifics of how each is implemented.

2.  Discuss the differences between the differential backup and transaction log backup. (detailed answer)

3.  How can you make a differential backup of the master database?

4.  Discuss the advantages and disadvantages of the three recovery models. (detailed answer)

5.  Discuss the similarities and differences between failover clustering, database mirroring and log shipping.

"Is this question part of your assignment? We can help"