Final Review

• Simple: All final changes in the transaction log are committed; Transaction log is truncated. SQL -SHOULD- also perform a shrinkfile operation
• Full: Nothing happens at a checkpoint. The .LDF file continues to grow and grow.Needs a maintenance plan. In most GOOD maintenance plans uses DBCC_SHRINKFILETransaction log backup·         Saves all information in the transaction log to a separate file.·         All final changes are committed to MDF·         Transaction log gets truncated·         DBCC_SHRINKFILEPoint in time Recovery file for the Transaction log
• Bulk-Logged: Nothing happens at a checkpoint. Needs a maintenance plan.

• MDF - Main datafile
• NDF - Same as MDF, used when MDF runs out of space
• LDF - Transaction Log data file

• Full - Takes a full backup of the entire DB and txn file
• Differential - Takes a backup of data that has changed since last full backup.
• Transaction log - Takes a backup of transaction logs for point in time recovery.

Listens for incoming requests for Microsoft SQL server resources and provides information and SQL server instances installed on the computer

• WITH_RECOVERY - Rolls back any uncommitted transactions, brings DB online for use
• WITH_NORECOVERY - uncommitted transactions are unaffected, database left in restoring mode allowing more transaction logs to be restored to the DB

• Log Shipping
• Mirroring
• Windows Clustering
• Always on availability groups

SQL resources are presented to and installed on multiple servers, The servers have the ability to move the instance between them in the event that a hardware failure occurs.

• 3 Job operation accomplished by setting up a maintenance plan.
• 1 - Transaction log backup of source database
• 2 - Copy transaction log backup to destination server
• 3 - restore transaction log backup to destination WITH_NORECOVERY

• 1 - Take fill backup of source DB
• 2 - Copy backup over to destination server, and restore to destination instance WITH_REVOCERY
• 3 - Take a transaction log backup on source DB
• 4 - copy to destination server
• 5 - restore to destination DB WITH_NORECOVERY
• 6 - Run regular log shipping again

Involves 2 SQL instances, a DB is configured specifically for mirroring on the source server and is called the "principle" db.  Another db is created on the destination instanced called the "mirror". Capable of automatic failover, but must be accompanied by a "witness" located on a third instance to do so.

• Syncronous - Changes to the db are copied to the mirror side and conformed before the are committed.  Requires a low-latency form of communication between the two instances.  Instances will match 100 %
• Asynchronous - Changes are made on the principle DB and are transmitted to the mirror and committed.  Disparity of data can occur

• Create
• Read
• Update
• Delete

• Insert
• Select
• Update
• Delete

• Master
• Model DB
• MSDB
• TempDB

• A type - IPv4 Address
• AAAA - IPv6 Address
• MX - Mail record
• Cname - Alias record
• Dname - Multiple Aliases
• PTR - Hostname
• TXT - Universal Record

• Recursive - Must be given a definitive answer
• Iterative - I don't know, but i know who does

• Primary - Full writable master copy of a DNS zone containing all records
• Secondary - Read only complete copy of the Primary zone
• Stub - A small read only that houses the A, NS, and SOA records

Is a DNS Server, that instead of doing a iterative query, it forwards the request to another DNS server.

• in-addr.arpa
• ip6.arpa

• Users and Groups
• Sites and Services
• Domains and Trusts
• Group Policy Managment

A group of domains that are within a security realm

Is a group of domains with a continues namespace

• replmon
• repadmin

• Domain Name Master
• Schema Master
• PDC Emulator
• Infrastructure Master
• RID Master

• dcpromo
• netdom
• ntdsutil

Is an incomplete list of objects and attributes within AD. Used for quick references.

DFS-N - (Name Space) Allows a network share to live under a namespace

DFS-R - Allows for a share to exist on more than one server, contents of the share are synchronized via one of two (or both) replication topologies

• Directional:
• Unidirectional - A can trust B, but B cannot trust A
• Bi-Directional - Users on both sides can login to resources on both sides
• Transitivity:
• Non-transitive - Domains only trust the domain that they hare a trust between, not to domains with a connected trust

Standard Port Monitoring

Used for URL monitoring

The utility that you use to manipulate Sitescope

Basic tool that monitors CPU, HD, and Memory

Windows tool that monitors CPU, HD, and Memory

• Hardware level monitoring system built into DELL server systems.
• Fires and "amber Light" when an error is thrown.

• Managment System for RBA and RS alert actions.
• - Creates Ticket Comments
• - Automations
• - SMTP responses
• - SMS responses

Automated tasks to produce a desired effect,

Example: simulate site functionality

• Storage Area Network:
• - Black level storage presented to servers over fiber channel HBAs
• - 8 GBPS Fiber Connection

• Direct-attach Storage
• - Shelves of drives connected directly to server via HBA
• - 6 GBPS Copper connection
• - Less Scalable (Max of 4 shelves)(RAID cannot jump shelves)

• Network Attached Storage
• - File level storage presented over copper ethernet
• - netapp units act as a fileserver
• - Only offering that supports native encryption of data at rest