The logical inconsistency in the database can lead to SQL Server database corruption. It badly impacts your valuable data by making it inaccessible and results as critical data loss situations. All database applications related to back- end and front-end roles of the SQL Server database get halted. In such cases, the only way to get your data back is to opt for sql database recovery.

When you try to open your SQL Server database (MDF file), you might encounter the following error message:

“Error: 824, Severity: 24, State: 2.

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:1863; actual 0:96). It occurred during a read of page (1:1863) in database ID 4 at offset 0×00000000e8e000 in file ‘F: \MSSQL.1\MSSQL\DATA\MSDBData.mdf’.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.”
After this error message, when you run DBCC CHECKDB command to check and fix database inconsistency problems, you might come across further error message stating:

“Msg 945, Level 14, State 2, Line 1
Database ‘magirisilica_s24′ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.”

This behavior of SQL Server causes data inaccessibility and data loss. To overcome this problem, you need to identify the cause of this problem and fix it by Repair SQL method.
Root of this issue
You might encounter data inaccessibility and database inconsistency problem due to MDF file corruption. Such corruption could be the result of issues like hardware problems, file system errors, virus infection, application malfunction and improper system shutdown.
Resolution
To sort out this problem and Repair SQL database to gain access of your lost data, you need to opt for sql recovery. It is the process of thoroughly scanning the damaged MDF file and extracting optimum amount of data from it.

It can be performed with the help of SQL Database Recovery software. These are highly automated tools that deploy efficient scanning methods to retrieve your data from damaged database file.
Stellar Phoenix SQL Recovery is the most comprehensive tool to ensure successful recovery of all MDF objects as tables, reports, queries, stored procedures, triggers, views, default values, rules, checks, constraints and indexes. It is compatible with Microsoft SQL Server 2005 and 2000. It supports Windows Vista, XP, 2003 and 2000.