Blogs from Suhas
Dirtying my hands in SQL Server
Copy On Write
Lock Pages in Memory
Minimum Recovery LSN
Not For Replication
SQL Server 2005
SQL Server 2008
Virtual Log File
Browse by Tags
Blogs from Suhas
Tagged Content List
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...
15 Aug 2011
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...
2 Aug 2011
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...
31 Jul 2011
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...
25 Aug 2010
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...
13 Jul 2009
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...
8 Apr 2009
Page 1 of 1 (6 items)
© 2013 Microsoft Corporation.
Privacy & Cookies