Sql Server 2000 Database Suspect

Started by VelMurugan, Dec 11, 2008, 02:55 AM

previous topic - next topic
Go Down

VelMurugan

Sql Server 2000 Database Suspect

With the SQL Server 2000, users found many administrative tools which offered the better relational databases development and maintenance. The tools like Query analyzer, Data Transformation Services, SQL Profiler, Service Manager and others eases the users' tasks in an effective way. SQL Server 2000 was the first file version to launch in a variant for the IA-64 architecture. Hence this gave better data storage temptations to the users and still in-use amongst many enterprises, though other file versions are making their individual place.

But, due to one or the other reason the SQL Server 2000 databases are found to be suspect after opening. Additionally, you get an error messages which prompts you to take SQL repair mechanism and reads out as:

<Date> <Time> spid9 Recovery of database 'UserDatabaseName' (5) is 2% complete (approximately 185 more seconds) (Phase 3 of 3).

<Date> <Time> spid9 Using 'dbghelp.dll' version '4.0.5' *Dump thread - spid = 9, PSS = 0x80178098, EC = 0x801783c0

<Date> <Time> spid9 The exception information has been submitted to Watson error reporting.

<Date> <Time> spid9 Stack Signature for the dump is 0x986D5509

<Date> <Time> spid9 SQL Server Assertion: File: <page.cpp>, line=3430 Failed Assertion = 'm_freeCnt + emptySlots * sizeof (Slot) >= spaceNeed'.

<Date> <Time> spid9 Location: page.cpp:3430 Expression: m_freeCnt + emptySlots * sizeof (Slot) >= spaceNeed

The mentioned error message is the fault of SQL Server itself. During the time when the row insertion is intended, if the application does mistakes while asserting free data page space, crisis can be seen with the database. Actually, the row to be inserted should have more space as compared to the available.

Though Microsoft offers a supported hotfix through its latest service pack, but there is no  SQL recovery way through it. This is available for the avoiding later such problems. Actually, the culprit transaction logs have caused the corruption causing changes in the database, much earlier. So your corrupted database has no recovery way, other than backup or third party applications.

MDF recovery is best possible via the complete backup. On the other hand, in its absence or existence in bad condition, MDF repair software will do a great job. Through their effective scanning algorithms, SQL recovery software will bring you success in restoring the corrupted database intact. SQL repair software have the set of worth features to offer the help.

Stellar Phoenix SQL Database Recovery uses the most powerful scanning algorithms and makes MDF recovery possible within moments. This is a fast, safe and easy-to-use MDF repair application, which proves good to be used with SQL Server 2000 and 2005.

This SQL recovery tool has an interactive interface and read-only design. The software valuable for all the database objects.

Source : ArticleBAse

zlatan24

#1
Aug 24, 2011, 04:31 AM Last Edit: Aug 24, 2011, 04:58 AM by zlatan24
Such problems with sql databases you can solve out with the help of repair mdf. It works under any computer requirements. The tool displays the results of working with lost or corrupted mdf files. It doesn't modify source data during recovering.

pradeep prem

with this sql server 2000 database
it has given many suspects to solve it easily or not in computer requirement

Go Up
 

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name:
Email:
Verification:
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview
IT Acumens Web Designing Chennai | GinGly :: Build your Personal Website | CineBuzz :: Cinema News | My Kids Diary :: Kids Memories Writing :: Book Website @ 349 Rs monthly
Copyright 2005 - 2020 :: IT Acumens :: All Rights Reserved. :: Sitemap
ITAcumens Discussion Forum with 2 lakhs post running for 15 years - Powered by IT Acumens Dedicated Server