Category: Troubleshooting

  • STEPS TO RESOLVE MICROSOFT SQL SERVER ERROR 18456

    STEPS TO RESOLVE MICROSOFT SQL SERVER ERROR 18456

    SQL (Structured Query Language) is basically a specific domain language, which is used in programming. It is designed for the process of Data Management in the RDBMS (Relational Database Management System) in addition to this, it can also be used in the RDBMS for stream processing. SQL is a popularly used language, however, sometimes it…

  • Troubleshoot Microsoft SQL Server Error Code 3241

    The users of MS SQL Server Database may encounter one of the common errors while trying to restore or attach the database from the backup file in the SQL Server Management Studio. The Error is commonly known as Error code 3241, which displays the following error message: The media family on device ‘backupfile.bak’ is incorrectly…

  • SQL DBA Cheatcode : 15 Things about SQL Server Error logs

    SQL DBA Cheatcode : 15 Things about SQL Server Error logs

    Today I am writing about some good facts about SQL Server Error logs.   SQL Server maintains its own error logs that contain messages describing informational and error events. “Error logs” is just the name but it contains warnings, error, information messages. 1. How to View SQL Server Error Log file location EXEC xp_readerrorlog 0,1,”Logging…

  • How to check SQL Server connection without SSMS?

    How to check SQL Server connection without SSMS?

    There are times when you need to verify SQL Server Connectivity from a machine there is no SQL Server Management Studio or any tool available. Not to worry, there are many ways to do this but the question is how easily can this be done? This question is often asked in DBA Interviews as well, “How to verify…

  • Misleading Message: DBCC execution completed. If DBCC printed error messages, contact your system administrator

    Misleading Message:  DBCC execution completed. If DBCC printed error messages, contact your system administrator

    Hello Reader, Recently, it was encountered that one of the jobs which was running fine since ages has started failing with below error message. Message : Executed as user: Domain\MSSQLServer. DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) SQLServerAgent Error: 32. [SQLSTATE 42000] (Error 22022). The step failed. So,…

  • System Databases : Restrictions Matrix

    System Databases : Restrictions Matrix

    Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that you “can not” perform on a system database. Below is a consolidated matrix (rows are restrictions) and when you see YES in the column, that means restriction is applied. If there is nothing, that…

  • Configure SSIS to use Named Instances

    Configure SSIS to use Named Instances

    SQL Server family has various services like Database Services (SQL Server), Analysis Services, Reporting Services which supports Named Instance of the services but there are few others like Integration Services which does not support named instance. This means, we can have one and only one service of Integration Services on each server. By default, the…

  • SQL Server Day to Day issues- Part2

    SQL Server Day to Day issues- Part2

    Here comes another issue that is being faced by DBAs frequently. (Read part 1 here) Issue- SQL Server Instance fails to start A number of problems can prevent the SQL Server service from starting. Let’s go through each of them. 1) Service account password incorrect or account locked or disabled If someone changes the SQL…

  • Script : Who all have access to SQL Server via AD Groups?

    Script : Who all have access to SQL Server via AD Groups?

    Dear Reader, Few days ago, I was looking for a script to find out who all have access to SQL Server via AD Groups. There are a couple of good scripts available for this task. However I thought of re-inventing the wheel. You are free to modify and re-share it. This script works with SQL Server…

  • SQL Server Day to Day issues – Part 1

    Here, I’m trying to share knowledge about Day to Day Issues while working with SQL Server and their quick resolution. Issue 1: Not able to access Database Properties Error : Property Owner is not available for Database. The Property may not exist for the object or may not be retrievable due to insufficient access rights.…

  • March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

    March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

    Lets talk about Traces and System procedures that are very useful for a DBA Routine. Interview Questions on Trace Flags What are trace flags? Trace flags are used to temporarily set specific server characteristics or to switch On/Off a particular behavior. Trace flags are frequently used to diagnose performance issues or to debug stored procedures.…

  • March towards SQL Server : Day 24 – SQL DBA Interview Questions Answers – SQL Server performance Tuning – 2

    March towards SQL Server : Day 24 – SQL DBA Interview Questions Answers – SQL Server performance Tuning – 2

    Dear Readers,   In this blog, I am taking a different approach. It’s very common that interviewer promptly asks another question from your answers only. Performance Tuning is the area where this can be done easily during any interview. Interviewer may just try to see if you really know about practical implementation of performance tuning…

  • March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning

    March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning

    Dear Reader, Today, I thought of writing interview questions on SQL Server Performance Tuning. I tried my best to touch upon many areas however Performance Tuning is something that can’t be covered end to end – you know that. Let me try starting from basic concepts to some scenarios type question. What is the use…

  • March towards SQL Server : Day 15 – SQL DBA Interview Questions Answers – Database Mirroring – 1

    March towards SQL Server : Day 15 – SQL DBA Interview Questions Answers – Database Mirroring – 1

    Next topic to High availability Questions Answers series is about Database Mirroring. This is very interesting topic and consists of very wide range of terminologies and scope. I will cover this topic in two blogs so that I can touch base all the possible Questions from Database Mirroring. 1. What is Database Mirroring? Database mirroring was…