Transaction Log Backup Size in Bulk Logged Recovery Model

Assume that I have a database in Bulk Logged Recovery Model, and I perform a bulk operation that is minimally logged. Now, if I take a Log Backup, should not my Log Backup File Size be smaller than if I had performed the same operation in Full Recovery Model? I have seen many people confused…

4

Advanced Performance Tuning – 1 :: Importance of data-types

Why did we develop DBMS systems? Not just for storing data – but also to be able to search for and retrieve stored data, and we define what our search criteria should be. This was probably true a couple of decades back, but we have come a long way now. With the huge advancement of…

5

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 then want…

4

INF: A missing exception handler can cause blocking and eventual application hang.

Very recently, I had the opportunity to help troubleshoot a Blocking issue that one of our customer’s was experiencing. In my experience, this is a very common scenario that I have seen. However, while troubleshooting this issue, and more so, while we wrote code to reproduce the issue at our end, we gained a lot…

1

Is NFR set?

Hi Friends, After a long break of about 8 months, I am back again!! Many things changed recently, and I was quite busy adopting to the changes – the most challenging was, of course, adopting myself to new parenthood. However, I am back again, with some new topics – topics that I have learnt or…

0