As you store more and more data to your Microsoft SQL Server database, the size of database increases and the performance of Microsoft SQL Server decreases day by day. Large size of database may also cause system crash and sometimes database corruption. To prevent such situations, MS SQL Server provides SHRINKFILE and SHRINDB tools for reducing size of the database. However, in some cases, these tools fail to shrink the database and problem remains intact. At this point, if database corruption occurs, SQL database repair becomes need of hour.
As a practical example of this behavior, you may come across the following error message when you try to reduce size of the SQL Server 2000 database using SHRINKFILE, SHRINKDB, or SQL Server Enterprise Manager:
"2002-11-25 22:41:30.18 spid55 Time out occurred while waiting for buffer latch type 4,bp 0x3d03340, page 1:37939357), stat 0xb, object ID 8:8:0, EC 0xB39B55E0 : 0, waittime 300. Not continuing to wait.
2002-11-25 22:41:30.18 spid55 Waiting for type 0x4, current count 0x100022, current owning EC/PSS 0xB39B55E0/0xB39B52B8."
If your computer is running the version of MS SQL Server later than MS SQL Server 2000 SP2, the below error message occurs:
"Server: Msg 8908, Level 22, State 6, Line 1 Table error: Database ID 7, object ID 8, index ID 0. Chain linkage mismatch. (1:679928)->next = (1:679929), but (1:679929)->prev = (1:679930)."
After this behavior, the shrink process gets interrupted and database remains in unusable and affected state. To retrieve data from such database, you need to take help of MS SQL recovery solutions.
You may run across this problem of Microsoft SQL Server 2000 database due to either of the following reasons:
The SHRINK operation is unable to remove any page from SYSFILES1system table on primary data file or MDF (Master Database File) file of Microsoft SQL Server database.
SQL Server database is severely damaged and can not be recognized by SHRINK tool.
Try out any of the below methods to carry out SQL Server recovery by fixing the issue:
Obtain latest service pack of Microsoft SQL Server.
Repair and restore corrupt database using commercial applications.
The MS SQL Repair
software are designed to scan corrupt database using high-end scanning techniques. They come equipped with simple graphical user interface to offer easy recovery in all SQL Server database corruption scenarios.
Stellar Phoenix SQL Recovery is the most advanced and efficient utility to offer assured recovery of corrupt MDF and NDF files. The software restores all database objects, such as tables, macros, reports, forms, triggers, and stored procedures. It works well with MS SQL Server 2008, 2005, 2000, and 7.0.