Find jobs | Company-wise jobs
Jobseekers | Employer login
About us Sitemap of www.CareerRide.com Sitemap FAQ related with www.CareerRide.com FAQ Click here to Contact us Contact
       
Submit Resume Free ! | Access Resume Free !
Home Interview Q&A Tutorials Oracle Sql server .NET Java Soft skills CV GD Work from home Online practice test FAQs in PDF Books Jobs FAQs
Interview questions                                 
SQL Server part 1
SQL Server part 2
SQL Server part 3
SQL Server part 4
SQL Server part 5
SQL Server part 6
SQL Server part 7
SQL Server part 8
SQL Server part 9
SQL Server 2008
Test your SQL Server skills!
Sql Server database maintenance
SQL Server backup
SQL Server cursor
SQL Server replication
Structured query language
SQL Server architecture
SQL Server constraints
SQL Server cursors
Data Mining
Data warehousing
SQL Server DTS
SQL Server functions
SQL Server indexes
SQL Server joins
SQL Server locks
SQL Server Net integration
SQL Server optimization
SQL Server replication
SQL reporting services
SQL service broker
SQL Server stored procedures
SQL Server table
SQL Server transactions
SQL Server transactions Architecture
SQL Server triggers
SQL Server views
SQL Server XML integration
SQL Server DDL
SQL Server DML
SQL Server DCL
SQL Server identifier
SQL Server data integrity
SQL Server accessing data
SQL Server subqueries
SQL Server cube operator
SQL Server insert data
SQL Server distributed queries
SQL Server index tuning
 

SQL Server - implications of server clustering on replication

Next>>         SQL Server tutorial  

SQL Server - implications of server clustering on replication - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

Explain the implications of server clustering on replication.

One should cluster the SQL Server on replication. While implementing replicating, SQL Server cluster participates as Publisher and a Distributor. Use a file share located on cluster disk as the snapshot folder. This will failover replication if SQL Server fails.

When configuring a clustered SQL Server as a Distributor, SQL Server needs access to to a snapshot folder as a temporary holding. To escape all this, make the SQL Server a Publisher and not a Distributor. Locate Distributor on a non clustered SQL Server. His enables snapshot folder to exit on a non SQL Server negating the above said.

SQL Server - implications of server clustering on replication - May 05, 2009 at 22:00 PM by Rajmeet Ghai

Explain the implications of server clustering on replication.

Server clustering on replication involves many manual and tedious tasks. The required folder on shared disk resource needs to be created with appropriate share with appropriate permissions. Using the cluster Admin, the shared folder needs to be configured as a clustered shared folder. 

SQL Server - implications of server clustering on replication - June 21, 2009 at 09:00 AM by Amit Satpute

Clustering involves a lot of complexities

If replication has to be implemented and the SQL Server cluster has to be involved as a Publisher and a Distributor, a file share located on the cluster disk resource should be used as the snapshot folder. By doing so, the replication will failover when SQL Server fails over.

A folder needs to be created manually on a shared disk resource along with granting the necessary permissions. Also, the shared folder needs to be configured using the cluster administrator as a cluster shared folder.


Next>>

Also read

What is Replication?
What are the types of Replication?
Define the terms used in Replication.
Describe the replication agents that SQL Server supports.
Describe in brief working of Replication.

 

 
Want to be hunted by potential employers? Just submit your key skills!

Popular FAQs

.NET .Net Architecture ADO.NET Java Oracle C#.NET
VB.NET DOT.NET AJAX ASP.NET NET Framework OOPS in .NET
C++ Sql Server Data warehousing EJB MySQL Linux
PHP UML Networking Testing XML  
 
Copyright © 2008 - 2010 CareerRide.com. All rights reserved.