Using Bulk Logged recovery model for Bulk Operations will Reduce the size of Transaction log backups – Myths & Truths

  It’s has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: "In a log shipping setup, to have smaller size T-log log backups being shipped to secondary,…

0

Understanding and Troubleshooting ‘Win2003 PF Usage’ on the server running SQL Server 2000

  I’ve been recently asked to explain the reason of high PF Usage on Windows 2003 server running SQL Server 2000 Enterprise Edition. Problem Statement: – From: OS Task Manager > Performance Tab: High value depicted in “PF Usage” graph. – On stopping SQL Server Service, the graph drops down. So does that mean that…

2

How to: Archive more that six SQL Server Error Logs using SSMS / EM

The following post describes how you can configure your SQL Server to archive more than six Errorlog files using SSMS (2008, 2005) or Enterprise Manager GUI. While I was aware of MS KB # 196909, that describes a way of increasing the number of SQL Server error logs, by way of Registry change, I was…

1

How to: Verify path for SQL Server Error Log Files

Hello Friends, March has been a busy month, and it is not over yet. Taking some time off to blog;  as small find “worth sharing”. While managing a SQL Server instance, there are so many different locations to look for MSSQL files, like SQL Server Error Logs. While we can easily locate path to SQL…

5