Author: Deepak
-
Database Snapshot
What is a Database Snapshot? * The Database Snapshot is a new feature that is available in Enterprise edition of SQL Server 2005. * It provides a read-only, static view of a database. * Multiple snapshots can exist for a single database on the same server instance as the database.
-
How Database Snapshot Works
Its essential that a DBA understands what happens when a snapshot is created. The following process happens, Database snapshots operate at the data-page level. Before a page of the source database is modified for the first time, the original page is copied from the source database to the snapshot. This process is called a copy-on-write…
-
How to configure Database Mirroring
I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Deepak —> Principal DeepakSansu —> Mirror DeepakTest —> Monitor
-
Log shipping – Sql2005
Log shipping allows you to automatically send transaction log backups from one database (known as the primary database) to a secondary database on another server (known as the secondary server). At the secondary server, these transaction log backups are restored to the secondary database, keeping it closely synchronized with the primary database. An optional third…
-
Role Change in SQL 2005 Log Shipping
In SQL 2000 where the role change was relatively easy through the use of stored procedures, unfortunately in SQL 2005 those SPs are no longer used and we have to perform the following steps to sync the secondary server with primary and then failover.