SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Failover consederations on Database Mirroring

These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring. This topic assumes that the user is familiar with the database mirroring concepts.
Failover Considerations
Depending upon the Transactions safety option with witness server, you can have Automatic failover or…

Read more

0 comments, 1,124 reads

Posted in Sanjeev SQL Master on 18 June 2012

Database Mirroring


This blog covers the High Availability Solutions provided by SQL Server i.e. Database Mirroring.

Database mirroring is a solution in SQL Server by which we can have the redundant copy of the database (Principal server) available on another server (Mirror Server) & incase of any disaster we can can…

Read more

0 comments, 1,652 reads

Posted in Sanjeev SQL Master on 5 March 2012

How to Upgrade SQL Server 2000 Instance to SQL Server 2005


The purpose of this tutorial is to lay out the general guidelines for planning a SQL Server 2005 upgrade. As the new version of SQL Server is coming, all the companies want to upgrade the older version of SQL Server to the newer version. Here the DBA role has…

Read more

0 comments, 1,670 reads

Posted in Sanjeev SQL Master on 21 February 2012

Recovery Modals in SQL Server

Being a SQL Server DBA, one should be able to understand how many recovery modals do we have in SQL Server.While determining the Backup starategies for you databases , we should give a deep dive into the recovery modals of the databases as they define the types of backups that…

Read more

0 comments, 734 reads

Posted in Sanjeev SQL Master on 3 February 2012


Dear All,

very good maorning to all of you.

Read more

0 comments, 502 reads

Posted in Sanjeev SQL Master on 3 February 2012