Categories
DBA

Installing SQL Server 2005

Before we begin the installation, login into the server with admin rights.

1.) Insert the SQL server CD DVD and wait for auto-menu to popup.

Categories
DBA

Moving System Databases — SQL Server 2000

Introduction:

There are lots of articles, Links and sites that describe how to move system databases from the SQL default location to the location described by the DBA but still lot of users find difficult while moving them and land up in trouble. So I thought that I would just do a graphical way of moving the databases so that the users can use the same and enjoy the task.

Categories
High Availability

Introduction to Database Mirroring

Overview of Mirroring:

Mirroring is mainly implemented for increasing the database availability. Similar to log shipping mirroring is also implemented on per database basis. Database mirroring maintains two copies of a single database that must reside on different instances of SQL Server Database Engine (server instances). Typically, these server instances reside on computers in different locations. One server instance serves the database to clients (the principal server), while the other server instance acts as a hot or warm standby server (the mirror server).