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. ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial