Final Review

  1. 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.
  2. 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
  3. 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.
  4. 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
  5. 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
  6. 3 types of SQL replication
    • Log Shipping
    • Mirroring
    • Windows Clustering
    • Always on availability groups
  7. 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.
  8. 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
  9. 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
  10. 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.
  11. 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
  12. Describe CRUD
    • Create
    • Read
    • Update
    • Delete
  13. TSQL CRUD
    • Insert
    • Select
    • Update
    • Delete
  14. What are the SQL databases
    • Master
    • Model DB
    • MSDB
    • TempDB
  15. DNS Record Types
    • A type - IPv4 Address
    • AAAA - IPv6 Address
    • MX - Mail record
    • Cname - Alias record
    • Dname - Multiple Aliases
    • PTR - Hostname
    • TXT - Universal Record
  16. DNS Queries
    • Recursive - Must be given a definitive answer
    • Iterative - I don't know, but i know who does
  17. 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
  18. What is a DNS forwarder
    Is a DNS Server, that instead of doing a iterative query, it forwards the request to another DNS server.
  19. Name the 2 reverse lookup zones
    • in-addr.arpa
    • ip6.arpa
  20. Name 4 AD MMCs
    • Users and Groups
    • Sites and Services
    • Domains and Trusts
    • Group Policy Managment
  21. Describe an AD forest
    A group of domains that are within a security realm
  22. Describe and AD tree
    Is a group of domains with a continues namespace
  23. AD replication tools
    • replmon
    • repadmin
  24. What are the FSMO roles
    • Domain Name Master
    • Schema Master
    • PDC Emulator
    • Infrastructure Master
    • RID Master
  25. AD command line tools
    • dcpromo
    • netdom
    • ntdsutil
  26. What is a Global Cataloging Server
    Is an incomplete list of objects and attributes within AD. Used for quick references.
  27. 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
  28. 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
  29. Describe Rackwatch
    Standard Port Monitoring
  30. Describe Sitescope
    Used for URL monitoring
  31. Describe RADAR
    The utility that you use to manipulate Sitescope
  32. Describe Nimbus
    Basic tool that monitors CPU, HD, and Memory
  33. Describe SCOM
    Windows tool that monitors CPU, HD, and Memory
  34. Describe Open Manage
    • Hardware level monitoring system built into DELL server systems.
    • Fires and "amber Light" when an error is thrown.
  35. Describe ARIC
    • Managment System for RBA and RS alert actions.
    • - Creates Ticket Comments
    • - Automations
    • - SMTP responses
    • - SMS responses
  36. Describe Vyugen Scripts
    Automated tasks to produce a desired effect,

    Example: simulate site functionality
  37. Describe SAN storage
    • Storage Area Network:
    • - Black level storage presented to servers over fiber channel HBAs
    • - 8 GBPS Fiber Connection
  38. 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)
  39. 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
Author
tntflashcards
ID
291260
Card Set
Final Review
Description
TNT final
Updated