Category Archives: SQL 2008 R2

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 [...]

250+ SQL Queries Interview Question Answers

SQL Interview Queries Question / Questions Answers This is a never ending topic and there is no limit to questions that all depends on profile and interviewer. I am trying my level best to divide questionnaire based on Experience in Query Writing skills 5+ Years of Experience (Expert) 2-5 Years of Experience (Intermediate) 1-2 Years [...]

Deadlock Analysis – READ Deadlock from SQL ERRORLOG

How to read DEADLOCK Information in SQL Server ERRORLOG ? In our previous posts, we learned how to trace dead lock information in SQL Server Errorlog. Once the this information is logged inside SQL Server Logs, then how can we use that information for deadlock analysis. In case you want to build your test scenario [...]

Example of Deadlock | SQL Server Deadlock Script

IS there a way I can stimulate a deadlock in SQL Server, so that I can use that as an example of deadlock Let’s take an example, where we will result / cause a dead lock to SQL Serve? To stimulate the Deadlock, let’s create two tables which we are going to use as an [...]