Error: "Could not retrieve backup settings for primary" in Log shipping Backup job

This one is simple but interesting… Log shipping which was running for an year, suddenly stopped working. Log shipping monitor says that there are no backups restored for last 14849 minutes… Why? We started figuring this out, the copy and restore jobs were running fine but only the backup job was failing. What was the…


Wow… We have MAXDOP calculator for SQL Server… It makes my job easier…

So after Max. Server Memory calculator, to make your life much more easier, here is the Max Degree of Parallelism or MAXDOP calculator. We are using SQL DMV’s to find out the number of NUMA nodes and Powershell query to find out the number of processor cores and then use the recommendations given in to give a MAXDOP value…


Cool… Now we have a calculator for finding out a Max. Server Memory value

This calculator is now withdrawn since I’m not able to invest my time to improve it to make it “stay current”. Apologize for the inconvenience!   Hello SQL Community, I have written a simplified “Max. Server Memory” calculator for calculating “Max. Server Memory” value for 64-bit SQL Server instances after seeing my blog referenced in MSDN forums,…


SQL Server 2012 Upgrade Technical Guide & What’s new Whitepaper Released

SQL Server team has published the “SQL Server 2012 Upgrade Technical Guide” at I encourage you to upgrade to SQL Server 2012 using this guide (HOW TO UPGRADE), What’s New whitepaper (WHY UPGRADE) downloadable from and other resources in the web site  


INF:What happens to a database when transaction rollback fails?

Today while working on a SQL Server performance case, I was asked this question “What happens to a database when transaction rollback fails?”. I thought of sharing the answer to the community so that it can help DBA’s to understand how SQL Server handles this scenario. So what happens when a transaction rollback fails? Database…


"Failed to save Local Policy Database" while granting any privilege to SQL Service SID in Group Policy Editor

When you try to grant any privilege to SQL Server Service SID using Group Policy Editor in Windows 2008, you might get this error: An extended error has occurred.Failed to save Local Policy Database. This happens only when you try to add virtual accounts like NT SERVICE\MSSQLSERVER NT SERVICE\SQLSERVERAGENT to grant certain privileges like Act…


"stop before startup" after "Using large pages for buffer pool" during SQL Server startup

Worked on a SQL Server startup issue which I would like to share here: Here is how the SQL Server errorlog looked like 2012-04-19 03:43:26.50 Server Microsoft SQL Server 2005 – 9.00.4035.00 (Intel IA-64) Nov 24 2008 12:59:53 Copyright (c) 1988-2005 Microsoft CorporationEnterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)……2012-04-19 03:43:26.52…


Restore database stuck at 90% waiting on PREEMPTIVE_OS_WRITEFILEGATHER

There are already few blogs and a KB to talk about this problem so I’m trying to tie them together to make sure you get this quickly When you are restoring a database (in my case a database having 32 files), post 90% complete, all but one threads in sysprocesses went into SUSPENDED state waiting…


Re-configure Replication after restoring publication database from Backup – Replication Scenario

Sharing one of the interesting scenario I worked today. Somebody messed up the data at publication database (few rows updated with a value which they aren’t supposed to) and publication database was restored from a older backup to rollback the change. Now when log reader agent was started it starting failing with an error: 2012-03-14 01:08:14.360…


Now Connect PHP website running in Linux Apache Webserver to SQL Server

How? Here is the answer: Preview of SQL Server ODBC driver for Linux is now available for download: Download Link: The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server More info: