Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 114

System Databases, Resource Database SQL Server 2005 or later

Get Computer Associates SQLSTQ99000600 - Unicenter SQL-Station 6.0.0 PDF manuals and user guides
UPC - 757943257441
View all Computer Associates SQLSTQ99000600 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 114 highlights

Microsoft SQL Server Database Basics For more information about File and FileGroup Backups, see Files and FileGroup Backups. (see page 121) For more information about Partial Database backups, see Partial Backups (see page 122). System Databases You can use CA ARCserve Backup to manage the protection and recovery of SQL Server system databases: master database The master database stores all system-level information for a SQL Server instance. msdb database The msdb database stores all information required by the automation agent service for SQL Server for scheduling alerts and jobs. model database The model database acts as a template for all databases created on a SQL Server instance. It stores metadata including database size, the recovery model, and other options that are inherited by each database you create. Resource Database (SQL Server 2005 or later) The Resource Database is read-only. It contains system objects required by SQL Server. It is not mounted as a live database, so the files are included in a file system backup rather than in a database backup. tempdb database The tempdb database holds memory-resident objects, or other temporary objects such as results needed for query operations. distribution database You may also have a Replication Distribution database, if your server is configured as a replication distributor. This database stores metadata and history information related to replication transactions and is sometimes referred to as the replication database. Databases for extended SQL Server services Additional databases may be created and used by certain features or secondary SQL Server components and services. These are handled the same as any production database in most cases. Important! The three main system databases (master, msdb, and model) are exempt from the Global or Rotation Job backup method. Selecting this option for these databases always results in a Full backup. 114 Agent for Microsoft SQL Server Guide

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
Microsoft SQL Server Database Basics
114
Agent for Microsoft SQL Server Guide
For more information about File and FileGroup Backups, see
Files and FileGroup
Backups.
(see page 121) For more information about Partial Database backups,
see
Partial Backups
(see page 122).
System Databases
You can use CA ARCserve Backup to manage the protection and recovery of SQL
Server system databases:
master database
The master database stores all system-level information for a SQL Server
instance.
msdb database
The msdb database stores all information required by the automation agent
service for SQL Server for scheduling alerts and jobs.
model database
The model database acts as a template for all databases created on a SQL
Server instance. It stores metadata including database size, the recovery
model, and other options that are inherited by each database you create.
Resource Database (SQL Server 2005 or later)
The Resource Database is read-only. It contains system objects required by
SQL Server. It is not mounted as a live database, so the files are included in
a file system backup rather than in a database backup.
tempdb database
The tempdb database holds memory-resident objects, or other temporary
objects such as results needed for query operations.
distribution database
You may also have a Replication Distribution database, if your server is
configured as a replication distributor. This database stores metadata and
history information related to replication transactions and is sometimes
referred to as the replication database.
Databases for extended SQL Server services
Additional databases may be created and used by certain features or
secondary SQL Server components and services. These are handled the
same as any production database in most cases.
Important!
The three main system databases (master, msdb, and model) are
exempt from the Global or Rotation Job backup method. Selecting this option for
these databases always results in a Full backup.