Data File Flashcards
1
Q
Primary role of msdb
A
to store information related to SQL Server Agent jobs, including scheduling, execution history, alerts, and operators
- it is a glue that holds everything together
2
Q
Tempdb
A
-holds temporary objects and temp variables
- cannot be set off line
-data file, log file or primary group cannot removed
- no snap shot
3
Q
MSDB stores
A
- used by SQL for alerts, jobs
- All the back up and inform where they stored are found here
- file group, data file or log file cannot be created
4
Q
Resource data base
A
A randomly database that obtains all the system object in a SQL server
5
Q
Master database contains
A
- All the system level information
- ## cannot start SQL server without it
6
Q
Model database
A
-Used as a templet created in a single instance
- change data capture cannot be enabled on model
- Files cannot be added
- triggers cannot be created
7
Q
A
8
Q
What are the five Datafile properties
A
logical name
File group
Initial size/Auto growth
File name
Path
Extension
9
Q
A
10
Q
GUI stands for
A
Graphic user interface
11
Q
A
