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
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 by this...
29 Dec 2010
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
Revealing the secrets - Truncating a Transaction Log File
In my earlier blog post on Shrinking the Transaction Log files in SQL Server , I had mentioned that a VLF can be truncated only when all transactions, that have at least one command written into the specified VLF have either been committed or rolled back. While this is true, I understand that it might...
18 Jul 2009
Shrinking the Transaction Log files in SQL Server
Hi Friends! This blog post is mainly to address concerns about increasing log file space, and how to go about to shrink the file. I am adding a priliminary content here as of now, but I will update this content as and when I get time and new content to add. Question: What is a log file, and why...
16 Mar 2009
Page 1 of 1 (4 items)
© 2014 Microsoft Corporation.
Privacy & Cookies