SQL Server errors: The Primary Filegroup is full

SQL Server errors: The Primary Filegroup is full “sql server error 1105 the ‘primary’ filegroup is full”  or ” Event ID: 1105 MSSQL$SQLEXPRESS – primary filegroup is full.”  error fix is provided in the article. primary filegroup is full sql server 2014 , needs Primary group to be extended because the ‘primary’ filegroup is full…

How to Resolve SQL Server Error 5172 – Fix SQL Server Header Error 5172

How to Resolve SQL Server Error 5172 – Fix SQL Server Header Error 5172 SQL Server stores its physical data in the primary database file, which contains the data by pages which store data. The header information of a .mdf file is stored by the first page, called a header page. This page contains the…

how to create a subroutine in a stored procedure in SQL Server?

How to create a subroutine in a stored procedure in SQL Server? You would seen procedures in Oracle that will call a subroutine within the same procedures for 50 times in different lines in the procedure. Now how do you recreate the same procedure in SQL Server? Explanation below: In SQL Server procedure, If subroutine…

SQL Server Database mirroring modes and patner timeout

The Two modes of Database Mirroring in SQL Server for HA/DR Solutions are Synchronous mirroring( High Availability / HA ) Asynchronous mirroring( Disaster Recovery / DR ) Synchronous mirroring : In all SQL Server databases, data changes are recorded in the transaction log before any changes to actual data pages are made. The transaction log records…

SQL Server Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405

Cause of Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “ when importing a database in your SQL instance you would find yourself with Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 popping out when setting the sa user as the DBO of the…

SQL Server error 18456 cannot connect – SQL Server 2017 LOGIN FAILED ERROR 18456

SQL Server error 18456 cannot connect – SQL Server 2017 LOGIN FAILED ERROR 18456 Normally error code comes up with a description that gives us a hint about what has gone wrong. But in this case of SQL Server error 18456 on screen, no cause of login failure is displayed. This is an intended development…

How to check Deadlocks in SQL Server

What is a SQL Server deadlock?What is a SQL Server deadlock? A deadlock in SQL Server occurs when 2 processes/sessions are competing for exclusive access to data in the tables but is unable to obtain exclusive access to it because the other process/session is preventing it. This results in a situation where neither process can…

SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified

SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified Error Details: this error message is often encountered when connection to a SQL Server is tried and don’t know where to start to solve the problem. We get this error message only when we are trying to connect to a SQL Server…

SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server

SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server Error Details or symptoms: Can not connect to a SQL server and you get a error a network-related or instance-specific error occurred while establishing a connection to sql server This error is seen in SQL Express installation as its installed…

SQL Server error 40 could not open a connection to sql server 2016

SQL Server error 40 could not open a connection to sql server 2016 Error related are: error 40 could not open a connection to sql server named pipes provider could not open a connection to sql server 53 invoke sqlcmd provider named pipes provider error 40 could not open a connection to sql server named…