Page 50 - DCAP508_DATABASE_ADMINISTRATION

Database Administration Sartaj Singh, Lovely Professional University

Notes Unit 4: SQL Server Storage Architecture

CONTENTS
Objectives
Introduction
4.1 Resource Database

4.1.1 Physical Properties of Resource
4.1.2 Backing Up and Restoring the Resource Database
4.1.3 Accessing the Resource Database

4.2 Database Physical Structure
4.2.1 Pages
4.2.2 Extents
4.3 Database Files
4.3.1 Logical and Physical File Names

4.3.2 Data File Pages
4.3.3 File Size
4.3.4 Database Snapshot Files

4.4 Transaction Log
4.4.1 Operations Supported by the Transaction Log
4.4.2 Transaction Log Characteristics
4.5 Summary
4.6 Keywords

4.7 Review Questions
4.8 Further Readings

Objectives

After studying this unit, you will be able to:

Discuss the meaning and importance of resource database
Describe how SQL Server databases and files are organized.
Comprehend the use of database files
Understand the concept of transaction log and its importance in SQL server

Introduction

This unit will explore the concepts relating to SQL Server storage architecture. It will help you
understand the meaning of resource database and how to work with resource database.

44 LOVELY PROFESSIONAL UNIVERSITY