Monthly Archives: June 2012

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information Error 8623 / 8632

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer [...]

Tivoli Data Protection SQL Server – Restore Database with different name

HOW TO RESTORE SQL Server Database with Different / Alternate NAME from backup created by Tivoli Data Protection (TDP) for Microsoft SQL Server ? Restore a backup from TDP library is pretty easy but you just need to be familiarized with tool to interact with Data Protection for Microsoft SQL Server. To Restore a USER [...]

SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state"

"SQL Server Database Services feature state". This was the Error Message, which I received this morning during building / Installing a SQL Server 2012 cluster. FIX / Resolution / Workaround : Change registry key on active node: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQLDEV2012\ConfigurationState] Change all entry values from 2 to 1 Incident happened to me in Detail I [...]

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed – SQL Server Reporting Services Error

User ‘DBATAG-DEMO\cluadmin’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. I received this error, when I was trying to configure SQL Server Reporting Services for “Scale-OUT Deployment” for NLB configuration. I was logged in as Domain / Enterprise Administration account still [...]

SQL Task to Delete Old Files from Server

As DBA we Schedule everything to automate the system as possible as we can and at times there is a requirement to delete old files from the Server. There are various ways to DELETE OLD FILES FROM SERVER Write a Script (VB / Power shell / BATCH) file to Delete Old LOG / Report files [...]

SEQUENCE BREAKS / GAP in Numbers after Restart SQL Server (gap between numbers after restarting server)

A user reported that there is huge GAP between numbers generated by SEQUENCE after restarting the SQL Server. bit surprised, Don’t worry this is Expected behavior of SQL Server. If you don’t know that Sequence like Identity is new feature of SQL Server 2012, please check my previouos post How to Create and use Sequence [...]

SQL Dumper Error – failed initialization Solution

SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer One of my friend called me and said, he is getting this error Every time when he starts his laptop ROOT [...]