Cargando…
Microsoft SQL Server 2008 High Availability /
In Detail Every business has it's mission critical applications and data. Therefore, it is very important to keep database servers up and running all the time - 24 X 7. There is a need to store and process terabytes of data to cater for business needs, and it is vital to make data highly availa...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
©2011.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; Foreword; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Preface; Chapter 1: Understanding Windows Domains, Domain Users, and SQL Server Security; Windows domains and domain users; Understanding SQL Server Security; Windows authentication; What is clustering?; How clustering works; MSDTC; Types of clusters; Single-instance Cluster; Multi-instance Cluster; Multi-site Failover Cluster; Guest Failover Clustering; Components of clustering; Shared disk array; The Quorum; Public and Private Network; Summary; Chapter 2: Implementing Clustering.
- What is Hyper-V?Installation prerequisites for SQL Server 2008 R2; Hardware requirements; Software requirements; Operating system requirements; Server role and feature; IP addresses; Network name; Shared disks; Installing a single-instance failover cluster; Adding a node to an SQL Server failover cluster; Installing the SQL server failover cluster using the command prompt; Installing SQL Server failover cluster using the Configuration file; Installing multi-instance (Active/Active) failover Cluster; Adding a node to a SQL Server failover cluster; Configuration; Write caching; File shares.
- Maximum memory sizeMinimum memory size; Preferred owners; LooksAlive; IsAlive; Restart; Affect the Group; Dependencies; File share; Anti Virus tool; Summary; Chapter 3: Snapshot Replication; Components of the replication; Types of replication; Snapshot Replication; Transactional Replication; Merge Replication; Peer-to-Peer Replication; Replication topologies; How replication works; Prerequisites for Snapshot Replication; Installing; Configuring Distributor and Publisher; Creating publication; Creating subscription; Configuring Snapshot Replication; Snapshot Agent; Distribution Agent.
- Maintenance jobsAgent history clean up: distribution; Distribution clean up: distribution; Expired subscription clean up; Reinitialize subscriptions having data validation failures; Replication agents check-up; Replication monitoring refresher for distribution; Configuring publication properties; Configuring alerts; Snapshot Agent parameters; Adding and dropping an article and a column to the existing publication using T-SQL; Summary; Chapter 4: Transactional Replication; Prerequisites for Transactional Replication; Working with Transactional Replication; Installing Transactional Replication.
- Creating new publication for Transactional ReplicationCreating subscription for Transactional Replication; Installing publication and subscription using T-SQL; Configuring Transactional Replication; Parameters to be configured with Distribution Agent profile; Summary; Chapter 5: Merge Replication; Merge Replication usages; How Merge Replication works?; Prerequisites for Merge Replication; Installing Merge Replication; Creating publication; Creating subscription; Configuration; Configuring publication using T-SQL; Configuring the Subscriber using T-SQL.