Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 442 reads

Posted in Sanjeev SQL Master on 18 June 2012

Database Mirroring

Introduction

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, 721 reads

Posted in Sanjeev SQL Master on 5 March 2012

How to Upgrade SQL Server 2000 Instance to SQL Server 2005


Introduction

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, 621 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, 379 reads

Posted in Sanjeev SQL Master on 3 February 2012

Sanjee-SQLMaster

Dear All,

very good maorning to all of you.

Read more

0 comments, 216 reads

Posted in Sanjeev SQL Master on 3 February 2012