-
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
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?
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
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
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
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…
-
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
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
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
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…