Blogs from Suhas

Dirtying my hands in SQL Server

Browse by Tags

Tagged Content List
  • Blog Post: Internals of Database Snapshot – Part 3: Snapshot and Mirroring

    In my earlier posts, we have seen how database snapshots work, and how the Buffer Pool is used when we query Snapshot Databases. In this post, we will see how Database Snapshots work, when they are created against Mirrored Databases. Let us assume we have a mirroring setup, as described in the below...
  • Blog Post: Internals of Database Snapshot – Part 2: Snapshot and the Buffer Pool

    In my earlier post, we have seen what Database Snapshots are, and how the Database Snapshots are maintained by the SQL Server Database Engine. In this post we will see how the data and index pages, belonging to the Snapshot, are managed in the Buffer Pool. Before we start drilling down further, let me...
  • Blog Post: Internals of Database Snapshot

    In this post, we will explore the internals of Database Snapshot. Most of this information is already available in the Internet, in the posts authored by the SQL Server Development Team and the CSS Escalation Team; however, through this post we will attempt to consolidate all of these information for...
  • Blog Post: INF: How to re-setup Database Mirroring In SQL Server

    One of my friends was asking this to me offline the other day: "I have Database in SQL Server, which is both Mirrored as well as Log Shipped. Log backups happen every 15 minutes; Mirroring happens in Synchronous mode and does not involve a witness. I want to break Mirroring (Remove Mirroring) and...
  • Blog Post: Step-by-step guide to configure Database Mirroring between SQL Server Instances in a Workgroup

    This post is again in response to requests from customers who want to know how to configure Database Mirroring between instances of SQL Server 2005 in a WORKGROUP. As you might have noticed, while configuring Database Mirroring using the GUI, it requires us to enter FQDNs of the servers; hence using...
  • Blog Post: Database Corruption Part 1 :: Introduction to Database Corruption in SQL Server

    Hello Everybody, I think you will all agree with me that database corruption is one of the nightmares in the life of a DBA. We store precious data in databases and each day the dataset grows bigger and bigger. A database corruption issue not only puts the data at risk, it also threatens to take a toll...
Page 1 of 1 (6 items)