Need help?

Our experts have had an average response time of 13.14 minutes in February 2024 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

Error 1474 severity 16 state 1 – How we fix it?

by | Jan 10, 2020

Looking for a solution to the Error 1474 severity 16 state 1? We can help you fix it.

Normally, this error occurs during the database mirroring.

At Bobcares, we receive requests to resolve the error as a part of our Server Management Services.

Today, let’s get into the details on how our Support Engineers fix this error

 

What is Database Mirroring?

In Database mirroring, we can create and maintain the redundant copies of a database. Database mirroring increases the availability of an SQL Server database.

Also, the Database mirroring minimizes the downtime which reduces the data corruption or loss.

There are two copies of a single database in Database Mirroring. The principal server instance provides the database to clients and the mirror server instance acts as a standby that can take over if the principal server has any problem.

 

When Error 1474 occurs?

Firstly, let’s have a detailed look at the error. Usually, the error occurs while configuring the database mirroring in SQL Server.

Error 1474 severity 16 state 1

 

Here the network is functioning correctly but the database is not active. The SQL Server checks for any database activity. In case, if there is no activity then it closes the database mirroring connection.

Now, let’s see how our Support Engineers fix it.

 

How we fix the error 1474 severity 16 state 1?

Till now we’ve discussed database mirroring in detail. Now let’s see how our Support Engineers fix this error.

1. Firstly we verify whether we are able to register the server instance on both principal and mirror servers.

2. Also, we add an entry to the hosts.etc file on both the principal and the mirror servers.

3. Next, we select the DNS section under the Local Area connection and Click Add. Then on the mirror server, we add the DNS Suffix of the principal server and vice versa.

4. After that, we configure the mirroring.

Finally, the error disappears and thus the error is fixed.

[Need any assistance with the mirroring errors? – We’ll help you]

 

Conclusion

In short, the error 1474 severity 16 state 1 occurs during the database mirroring. In today’s write-up, we discussed errors and saw how our Support Engineers fixed it for our customers.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Categories

Tags

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF