-
SQL Recovery Models
- 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.
-
What are the SQL file types
- MDF - Main datafile
- NDF - Same as MDF, used when MDF runs out of space
- LDF - Transaction Log data file
-
SQL Backup Types
- 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.
-
Describe the SQL Server Browser
Listens for incoming requests for Microsoft SQL server resources and provides information and SQL server instances installed on the computer
-
2 ways of restoring a database
- 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
-
3 types of SQL replication
- Log Shipping
- Mirroring
- Windows Clustering
- Always on availability groups
-
Describe Windows Clustering
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.
-
Describe Log Shipping
- 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
-
Steps on fixing Log Shipping
- 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
-
Describe SQL mirroring
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.
-
2 Ways to configure SQL mirroring
- 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
-
-
-
What are the SQL databases
-
DNS Record Types
- A type - IPv4 Address
- AAAA - IPv6 Address
- MX - Mail record
- Cname - Alias record
- Dname - Multiple Aliases
- PTR - Hostname
- TXT - Universal Record
-
DNS Queries
- Recursive - Must be given a definitive answer
- Iterative - I don't know, but i know who does
-
DNS Zones
- 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
-
What is a DNS forwarder
Is a DNS Server, that instead of doing a iterative query, it forwards the request to another DNS server.
-
Name the 2 reverse lookup zones
-
Name 4 AD MMCs
- Users and Groups
- Sites and Services
- Domains and Trusts
- Group Policy Managment
-
Describe an AD forest
A group of domains that are within a security realm
-
Describe and AD tree
Is a group of domains with a continues namespace
-
-
What are the FSMO roles
- Domain Name Master
- Schema Master
- PDC Emulator
- Infrastructure Master
- RID Master
-
-
What is a Global Cataloging Server
Is an incomplete list of objects and attributes within AD. Used for quick references.
-
Describe both types of DFS
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
-
Describe both types of AD trusts
- 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
-
Describe Rackwatch
Standard Port Monitoring
-
Describe Sitescope
Used for URL monitoring
-
Describe RADAR
The utility that you use to manipulate Sitescope
-
Describe Nimbus
Basic tool that monitors CPU, HD, and Memory
-
Describe SCOM
Windows tool that monitors CPU, HD, and Memory
-
Describe Open Manage
- Hardware level monitoring system built into DELL server systems.
- Fires and "amber Light" when an error is thrown.
-
Describe ARIC
- Managment System for RBA and RS alert actions.
- - Creates Ticket Comments
- - Automations
- - SMTP responses
- - SMS responses
-
Describe Vyugen Scripts
Automated tasks to produce a desired effect,
Example: simulate site functionality
-
Describe SAN storage
- Storage Area Network:
- - Black level storage presented to servers over fiber channel HBAs
- - 8 GBPS Fiber Connection
-
Describe DAS Storage
- 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)
-
Describe NAS Storage
- 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
|
|