Repair SQL server 2000 ?
Currently I am using SQL server 2000. I found one suspect database and I have set it to standby/emergency mode by updating sysdatabase table. Then I started to execute it.
DBCC CHECKDB (\'amit\', REPAIR_ALLOW_DATA_LOSS)
But it throws an error-----
Could not run BEGIN TRANSACTION in database ‘amit\' because the database is in bypass recovery mode.
After this I tried using
DBCC CHECKDB (‘amit\') WITH ALL_ERRORMSGS, NO_INFOMSGS
It also throws one error—
Table error: Database \'mydb\', index \'meal_plan.IX_meal_plan\' (ID 1653632984) (index ID 2)
I am not able to drop this index because whenever I try to drop this I got error messages same as first one. I am not able to access my database. I think it would need SQL repair. Can anyone suggest me the perfect SQL 2000 database repair tool?
Know the Answer? Share it...
Repair SQL server 2000 ?
Related Question
Slow performance of SQL server 2005 ?
State a way with which I can get fixed my entire corrupt SQL Database? ?
Suggest a Recovery for repairing the Read only Database in SQL 2000 ?
Is Mdf Repair Software best for SQL Server files of 2005? ?
Suggest for a Database Repair Tool for SQL Server 2005 ?
Suggest a process for fixing a table in Ms Sql? ?
How can you recover the Index Fragmentation in the SQL Database? ?
State a recovery for the corrupt index Database of Ms Sql. ?
Make a recovery for MDF files which has got deleted unexpectedly. ?
You are not allowed to access the database from this machine, please verify your access id or contact database administrator”. What this message indicates? ?
Incorrect Key File for table”….Try to repair it.” What this message specifies? ?
Database got corrupt by SQL Injection Attacks”. How to Repair ?
I am middle in the problem. Facing error in I/O operation on sql. Give solution for best command to repair mssql database ?
The error is generated in database. How to check db space mssql ?
SQL database giving an error on 2000 sql repair tool is working slowly. What to do ?
Getting the errorin SQL 2005: # table corrupted # buffer is too small, unavailability of free disk space. ?
How to run dbcc on mdf file on MS SQL server 2005. Describe some solutions ?
The SQL server log file giving error. How can be repairing ms sql log files ?
my SQL table database does not return any value. How to restore table from mdf file ?
The MS SQL has generated an error while restoring the database. How to recover mssql database ?
SQL is giving an encrypted error. How to fix mdf file of sql server 2005 error ?
Table error: Object ID 0, index ID 0, page ID (1:105). The PageId in the page header = (0:0) ?
Bug in libmysql.dll ?
Destroyed key cache still usable ?
Problem with intensive locking (deadlocks?) during execution of system_1_test ?
Merge table with INDEX statements out of order returns NULL for index columns ?
Overflow must be an error ?
Table name in Error message not in default character set ?
Lost Data with delayed insert or mysqlhotcopy or lock and flush ?
