Database is in suspect state

Source: Internet
Author: User
Tags sql server books server error log

After the physical machine installs the update, restarts, discovers one db is in the suspect state, this DB's Files distributes on the different Server, I suspect is when the remoteserver restarts, causes the DB to have no access to the remote Files, so SQL Server Enter the suspect state.

Review the Windows Log report and find the error message:

The operating system returned error (the network path is not found.) to SQL Server during a read at offset 0x000001bed0 8000 in file ' \\RemoteServerName\ShareFolder\xxxx.ndf '. Additional messages in the SQL Server error log and system event log could provide more detail. This is a severe system-level error condition the threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can is caused by many factors; For more information, see SQL Server Books Online.

Workaround

This error is due to remote server reboot, which prevents DB from accessing files located on remote server. When all remote servers are restarted, the DB service is restarted, and once SQL Server instance detects that all files of DB are in normal access, the DB returns to normal.

Reference doc:

How to Repair A Suspect Database in MSSQL

Recovering a SQL Server Database from Suspect Mode

Database is in suspect state

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.