Trace flags are used to gather in-depth information about certain logs during some transactions. We use DBCC commands to enable trace flags, disable trace flags or check the status of trace flags. Here i am going to discuss about SQL...
We got error 1418 while configuring Database Mirroring on one of the SQL Server database instance. The error details are given below: The server network address “TCP://ServerName.abc.local:5022″ cannot be reached or does not exist. Check the network address name and...
Today, I got SQL Server error 233 no process is on the other end of the pipe while connecting to one of the SQL Server instance using SSMS client. SQL Error 233 was saying No process is on the other...
Today, I will explain how to fix SQL Server error 53 (The network path was not found). The details about SQL error 53 are given as “A network-related or instance specific error occurred while establishing a connection to SQL Server....
Today, a user has raised a request to fix an error (Microsoft SQL Server Error 40 – Could not open a connection to SQL Server or Microsoft SQL Server, Error 2) he was getting while establishing the database connection. Sometimes you might...
Today I am going to discuss about Microsoft SQL Server Error 28 that most of the SQL Server users might have faced at least once in their career. It belongs to SQL Server connectivity issue SQL Network Interfaces Error 28....
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a SQL Server database. Have you ever thought how SQL Server initialized its database files during space allocation? General way to...
We had successfully installed SQL Server on this server but we have received error “MMC could not create the snap-in” during launching SQL Server Configuration Manager after a week. I did some google search to fix this issue but nothing...
