O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide by David W. Tschanz, J. Steven Jones

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12

Designing a Data-Archiving Solution

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Select archiving techniques based on business requirements.
    • Gather requirements that affect archiving.
    • Ascertain data movement requirements for archiving.
  • Design the format of archival data.
  • Specify what data to archive.
    • Specify the level of granularity of an archive.
    • Specify how long to keep the archives.
  • Plan for data archival and access.
    • Specify the destination for archival data.
    • Specify the frequency of archiving.
    • Decide if replication is appropriate.
    • Establish how to access archived data.
  • Design the topology of replication for archiving data.
    • Specify the publications and articles to be published.
    • Specify the distributor of the publication. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required