-
Written By Robert Scott
-
Updated on December 19th, 2024
Summary: You can encounter the following messages such as: “ Msg 605, Level 21, State 3, Line 1 – Attempt to fetch logical page (1:224) in database 11 failed. It belongs to allocation unit 72058253744865280, not to 72057594040287232.” This error is encountered when there is damaged MDF files which are inaccessible from the SQL database. However, the precise reason is unknown. To resolve error 605 in SQL Server, many times, you might need the professional expertise of a SQL server expert. Let’s see How to Resolve error 605 in SQL Server using manual method and professional SQL database recovery tool.
Download Now Purchase Now
There are two types of severity in this error,
Severity 21: In this, the problem could be with the pages of database or with engine of SQL server while learning the actual value of expected allocation.
Severity 12: This is caused when the server query uses read uncommitted isolation level or NOLOCK query hint.
Error Msg 605 appears when a user tries to log through the system other than the system administrator. The error appears in RED color.
When severity level is 21, the user session gets terminated and the error is registered in SQL error log and Windows Application Event Log as Event ID 605.So, this is how you know this error has occured.
You can experience severity level 12 only when it is returned from client application and also if the query flops in situation when it is utilizing read uncommitted isolation level.
Also Read:- How To Fix Microsoft SQL Error 18456-Login Failed Error
First and foremost, you should always keep the backup of your data to minimize loss of valuable data.
You can follow the following steps.
First of all you need to have the right information about the data file and page number given in error message,then use the DBCC PAGE command.
dbcc traceon(3604)
dbcc page(‘MyDatabaseName’,1, 224,3)
dbcc traceoff(3604)
NOTE: You could use any of the 0,1,2,3 options as the last parameter (bold 3) of DBCC PAGE command. You have two different options to choose from:
According to experts, it is recommend to opt for the 1st option, but just in case you don’t have last full backup, the you could easily opt for a second option. Given below TSQL, follow the commands to restore the page from the last complete database backup
RESTORE DATABASE MyDatabaseName
PAGE = ‘1:224’
FROM DISK = ‘D:\MyDatabaseName.bak’
WITH NORECOVERY
But, it can happen that you don’t have the required backup, then the best option is to use DBCC CHECKDB command.
If there is no backup of the data, then first you require to verify about the severity level i.e. 21 or 12.
DBCC CHECKDB (‘MyDatabaseName’) WITH NO_INFOMSGS
After executing the above command, it might be recommended to use REPAIR_REBUILD.
Note: If you see repair level REPAIR_ALLOW_DATA_LOSS, unfortunately you may lose some of your data. Follow the command below:
In case of severity level 12, you can follw the steps given below:
These steps may provide you with some relief from error 605 in sql server, but still, these steps do not guarantee high-end qualitative as there is a probability that the SQL server edition may not favor the retrieval process making your job tough. So, to resolve error 605 in SQL Server, you may need a more profesional solution.
There are many types of databases like MS SQL Server 2014/2012/2008 R2/2008/2005 can be used to store the MDF files. It might happen that theabove mentioned approach does not works well for SQL Server 2014, then it would become impossible to fetch and secure the data.
Therefore, it is necessary to make use of a tool that can guarantee the recovery of corrupt MDF files to resolve error 605 in SQL Server
If you want complete recovery of corrupt MDF file components like Triggers, Rules, Functions, Tables, and Stored Procedures, etc. If you wish to preview the recovered file components, then you are recommended to install the DatabaseFileRecovery SQL database recovery tool.
In this blog, I have tried to explain the methods to resolve error 605 in SQL Server with different severity levels. You can try running the above-explained commands for recovery, but it is not a hundred percent efficient option for recovery. So, you can use the professional tool to resolve error 605 in SQL Server
About The Author:
With more than five years of experience in email migration, Data Recovery, Email Backup, and File Management, I combine my years of experience with a strong interest in new technology. My professional journey is fueled by a genuine passion for navigating and mastering the latest advancements in these fields, ensuring that I stay ahead of the curve and bring innovative solutions to the table.
Related Post
© Copyrights 2017-2024 Database File Recovery. All Rights Reserved.