IBM:
1. How many IP’s are required for 2 node cluster?
Ans: 6
2. Brief about IP’s usage?
Ans: 6 IP ( 2 external IP (public), 4 Private IP)
3. Scenario: My SQL server instances are working fine on Node A but instances are not failover from Node B, what could be the reason?
Ans: Network down
4. What are differences between SQL 2005 and 2008 w.r.t Cluster?
Ans:
5. What are the differences between SQL 2005 and SQL 2008 installation wise?
Ans:
6. What are the agents created when we configure Transactional replication?
Ans: snapshot agent, distribution agent
7. How to trouble shoot if Primary key violation is happened in Transactional replication?
Ans: sp_browsereplcommands
8. How transactions are move between Publisher to Distributor and Distributor to Subscriber?
Ans:
9. What is difference between Transactional replication and Merge replication?
Ans:
10. What is diff between Log shipping and Mirroring?
Ans:
With Log Shipping:
Data Transfer: T-Logs are backed up and transferred to secondary server
Transactional Consistency: All committed and un-committed are transferred
Server Limitation: Can be applied to multiple stand-by servers
Failover: Manual
Failover Duration: Can take more than 30 mins
Role Change: Role change is manual
Client Re-direction: Manual changes required
With Database Mirroring:
Data Transfer: Individual T-Log records are transferred using TCP endpoints
Transactional Consistency: Only committed transactions are transferred
Server Limitation: Can be applied to only one mirror server
Failover: Automatic
Failover Duration: Failover is fast, sometimes < 3 seconds but not more than 10 seconds
Role Change: Role change is fully automatic
Client Re-direction: Fully automatic as it uses .NET 2.0
11. I want to give permissions to only one job for creation/deletion of that job only, out of 100’s of jobs, how?
Ans:
12. Where we find Log files for clustering?
Ans: c:/program files/ windows/cluster.log
13. How to move Tempdb, Is it require to re-start sqlserver?
Ans: Yes
1. How many IP’s are required for 2 node cluster?
Ans: 6
2. Brief about IP’s usage?
Ans: 6 IP ( 2 external IP (public), 4 Private IP)
3. Scenario: My SQL server instances are working fine on Node A but instances are not failover from Node B, what could be the reason?
Ans: Network down
4. What are differences between SQL 2005 and 2008 w.r.t Cluster?
Ans:
5. What are the differences between SQL 2005 and SQL 2008 installation wise?
Ans:
6. What are the agents created when we configure Transactional replication?
Ans: snapshot agent, distribution agent
7. How to trouble shoot if Primary key violation is happened in Transactional replication?
Ans: sp_browsereplcommands
8. How transactions are move between Publisher to Distributor and Distributor to Subscriber?
Ans:
9. What is difference between Transactional replication and Merge replication?
Ans:
10. What is diff between Log shipping and Mirroring?
Ans:
With Log Shipping:
Data Transfer: T-Logs are backed up and transferred to secondary server
Transactional Consistency: All committed and un-committed are transferred
Server Limitation: Can be applied to multiple stand-by servers
Failover: Manual
Failover Duration: Can take more than 30 mins
Role Change: Role change is manual
Client Re-direction: Manual changes required
With Database Mirroring:
Data Transfer: Individual T-Log records are transferred using TCP endpoints
Transactional Consistency: Only committed transactions are transferred
Server Limitation: Can be applied to only one mirror server
Failover: Automatic
Failover Duration: Failover is fast, sometimes < 3 seconds but not more than 10 seconds
Role Change: Role change is fully automatic
Client Re-direction: Fully automatic as it uses .NET 2.0
11. I want to give permissions to only one job for creation/deletion of that job only, out of 100’s of jobs, how?
Ans:
12. Where we find Log files for clustering?
Ans: c:/program files/ windows/cluster.log
13. How to move Tempdb, Is it require to re-start sqlserver?
Ans: Yes
