Manual Failover Cluster

Manual Failover Cluster Hi friends, in this post we will learn how to manual Failover SQL Server Cluster. Earlier we had learnt how to configure a two node SQL Server Failover Cluster. Step by Step SQL Server 2008 R2 Clustering Part 1 Step by Step SQL Server 2008 R2 Clustering Part 2 Step by Step

Step by Step SQL Server 2008 R2 Clustering-Part 3

Step by Step SQL Server 2008 R2 Clustering-Part 3 Hi Friends, this is part 3 of our clustering series Step by Step SQL Server 2008 R2 Clustering and Step by Step SQL Server 2008 R2 Clustering-Part 2. On Part 1 we had competed Creating two Virtual Disk, Added two user for SQL Server & SQL Server Agent Services to

Step by Step SQL Server 2008 R2 Clustering-Part 2

Step by Step SQL Server 2008 R2 Clustering-Part 2 (How to Configure SQL Server Clustering) Hi Friends, this is part 2(How to Configure SQL Server Clustering) of our last post Step by Step SQL Server 2008 R2 Clustering, on that post we had competed Creating two Virtual Disk, Added two user for SQL Server & SQL Server

Step by Step SQL Server 2008 R2 Clustering

Step by Step SQL Server 2008 R2 Clustering Hi Friends, in this post we will learn How to Configure Step by Step SQL Server 2008 R2 Clustering. Step by Step SQL Server 2008 R2 Clustering Part 1 Step by Step SQL Server 2008 R2 Clustering Part 2 Step by Step SQL Server 2008 R2 Clustering

Run a SQL Server Job on Conditions of Different Job

Run a SQL Server Job on Conditions of Different Job Hi Friends yesterday i got a mail from my project manager, regarding a job. Which is scheduled for 6:00 PM on daily basis. But he want to implement some conditions for it. Scenario: Actually I have configured a job in SQL Server which is executed

How to Extract Only Date from Getdate in SQL Server

How to Extract Only Date from Getdate in SQL Server Hi friends, in this post we will learn How to Extract Only Date from Getdate in SQL Server or you can say that How to return the date part only from a SQL Server datetime. Sometime we have requirement of only date part from our datetime datatype or