Categories
Sql Server

SQL Server Database Mirroring in Domain Environment

SQL Server Database Mirroring in Domain Environment Hi friends, in this post we will discuss how to configure SQL Server Database Mirroring in Domain Environment. Earlier we have discussed How To Set Up Database Mirroring In Windows Workgroup. Here are some conditions to be meet to configure Database mirroing: For a mirroring session to be […]

Categories
Sql Server

How to Configure Scheduled Backup in SQL Server Express Edition

How to Configure Scheduled Backup in SQL Server Express Edition Hi friends in this post we will learn how to configure scheduled backup in sql server express edition. First of all let we all know that sql server express edition cannot use sql server agent, and all our scheduled task are done through sql server […]

Categories
Sql Server

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 […]

Categories
Sql Server

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 […]