Subscribe to this blog
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…
0 comments, 282 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…
0 comments, 518 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…
0 comments, 383 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…
0 comments, 307 reads
Posted in Sanjeev SQL Master on 3 February 2012
Sanjee-SQLMaster
Dear All,
very good maorning to all of you.
very good maorning to all of you.
0 comments, 140 reads
Posted in Sanjeev SQL Master on 3 February 2012