SQL Server Replication Fundamentals LiveLessons
English | Size: 2.27 GB (2,435,192,742 Bytes)
Everything you need to know in der to implement and wk with SQL Server Replication!
Replication is a common method of moving from one SQL Server to another. It enables moving data to a repting server, creating a basic failover site, providing data to development environments, and addresses many other issues. Most DBAs have will encounter Replication when wking with SQL server. The Replication system is large enough that it is often difficult to master without some fm of training. SQL Server Replication Fundamentals LiveLessons provides the infmation needed in der to wk with replication.
Every SQL Server Admin in the market needs to understand Replication in der to do their jobs. Individuals in the accidental DBA categy who find Replication installed on their system, also need to understand how to use it. This LiveLesson covers all the basic building blocks of Replication. Expert Eric Johnson begins with a basic overview of the components and terms and progress into advanced configuration and troubleshooting. There is a lot to learn in der to use Replication crectly. The configuration is very visual and often me easily explained with this medium than any other delivery mechanism. This LiveLesson uses the most current version of SQL Server, but almost all the content can be applied to SQL Server versions as far back as 2005, and in some cases, even older versions of SQL Server.
Beginner to Intermediate
What You Will Learn
* Help admins understand replication so they are able to configure and administer it in their environments.
* Teach crucial replication topics like troubleshooting, transactional publications, and moniting.
* Provide the basic knowledge needed to be able to select an appropriate replication topology to solve the problem at hand.
* Give detailed knowledge of the parts of replication so that they may customize the configuration f their needs.
* Offer the ability to identify the type of replication in use and make the crect decisions regarding the administration of the servers running replication.
Who Should Take This Course
* SQL Server admins
* SQL Server developers
* Any developer, Administrat, DBA that has to wk with SQL Server
* Some familiarity with SQL Server
Table of Contents
Lesson 1: Overview of SQL Server Replication
1.1 Define Replication
1.2 Identify Replication Types
1.3 Understand Server Roles
1.4 Identify Replication Agents
Lesson 2: Configuring Replication
2.1 Set up Distribution
2.2 Set up Publishing
2.3 Set up Subscribers
Lesson 3: Wking with Snapshot Replication
3.1 Configure Snapshot Replication
3.2 Wk with Snapshot Options and Settings
3.3 Generate Snapshots
3.4 Configure Snapshot Agent Profiles
Lesson 4: Wking with Transactional Replication
4.1 Configure Transactional Replication
4.2 Create Subscriptions
4.3 Synchronize Transactional Subscriptions
4.4 Modify Publications
4.5 Understand Replication Sted Procedures
4.6 Configure Distribution Agent Profiles
Lesson 5: Wking with Merge Replication
5.1 Configure Merge Replication
5.2 Synchronize Merge Subscriptions
5.3 Understand Replication Triggers
5.4 Configure Merge Agent Profiles
Lesson 6: Wking with Peer-to-Peer
6.1 Configure Peer-to-Peer
6.2 Wk with Peer-to-Peer Replication
Lesson 7: Special Considerations f Replication
7.1 Use Identities in Replication
7.2 Replicate Indexes and Feign Keys
7.3 Understand the NOT F REPLICATION Option
7.4 Backup Replication with Scripts
Lesson 8: Configuring Replication Security
8.1 Configure the Publication Access List
8.2 Identify Accounts with Replication Access
8.3 Set up Permissions
Lesson 9: Troubleshooting and Moniting Replication
9.1 Use Replication Monit
9.2 Identify Replication System Tables
9.3 Use the Igne Err Option
9.4 Understand the MSdistribution_status View
About LiveLessons Video Training
I recommends Buy premimum account for High speed+parallel downloads!