/build/static/layout/Breadcrumb_cap_w.png

Repair Corrupt Database?

one of my SQL database corrupt. and i dont have any backup ......i got 

the bigest prob. i tryed to repair will all the 'DBCC' command but none 

of those works.. i tried 'dbcc checkdb', 'dbcc CHECKALLOC', 'DBCC 

CHECKTABLE' but none of this find any problem. is there any extra tools 

or other command to repair MSQL 7.0 Database. please helpppppp 

please....

In access i always Jet4 repair database command but what should i use 

in SQL?

2 Comments   [ + ] Show comments
  • did you put the DB in single user mode? Here are some links to tips and packages you might have to end up buying:

    https://mhlavaty.wordpress.com/2012/04/24/how-to-repair-microsoft-sql-database/

    http://www.stellarinfo.com/gdc/sql-recovery.php?gclid=CMKk8uLzxsUCFdcXHwod55oAaA

    http://www.sysinfotools.com/recovery/ms-sql-database-recovery.html

    http://www.en.sqldatabaserepair.org/ - JordanNolan 8 years ago
  • Access File Recovery Tool, That application repairs & recovers data from corrupt Access database file. It can also recovers and repairs data of .MDB and .ACCDB files of access database.

    You can also download:- http://www.mannatsoftware.com/stellar-phoenix-access-recovery.html - AldoRoesch 8 years ago

Answers (7)

Answer Summary:
Posted by: axtonlindsey 8 years ago
White Belt
1

Top Answer

Restore WithTransact-SQL

 

-Click “NewQuery” in the Management Studio’s main toolbar. This opens a large text area onthe right side of the screen.

 

-Click in thetext area and type a Create Database statement using the following Transact-SQLcode as a guide:

CREATE DATABASEMyDatabase ON (FILENAME = 'c:\data files\my_data.mdf'), (FILENAME = ' c:\datafiles\my_data.ldf') FOR ATTACH;

 

-Click the“Execute” button in the Transact-SQL toolbar, located just under the ManagementStudio’s main toolbar. The Execute button symbol is a right-pointing triangle.SQL Server Management Studio restores the database.

 

Helpfulresources to explain another methods of restoration and gave more variants ofsql data recovery...

https://social.technet.microsoft.com/Forums/en-US/cc4cfcf8-93ad-4d8e-98db-9f241543da89/my-database-mdf-file-got-corrupted?forum=ssdsgetstarted

http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1492-sql-database-corruption-on-sql-2014

https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox

Posted by: AldoRoesch 8 years ago
White Belt
0
Here is one of the best solutions that can easily fix all corruption issues in ACCDB and MDB database with Access File Recovery Tool that easily repairs corrupt MS Access (.MDB or .ACCDB) database file and then recover tables, queries, forms, macros, reports, etc. It also restores permanently deleted data from MDB file of MS Access 2013, 2010, 2007, 2003, 2002, 2000 on your latest Windows 8.1 PC & all below Windows version like as Win8, Win7, Vista, 2003 and XP.

For more Help please visit here.. http://www.mannatsoftware.com/stellar-phoenix-access-recovery.html

Posted by: anonymous_9363 8 years ago
Red Belt
0
First, do NOTHING until you have copied the database files somewhere safe!! You don't want to completely negate any chance of recovering your data.

Second, source a backup program and use it! More importantly, you absolutely *have* to test that the back-ups can be restored. I cannot count the number of clients I've worked for who don't do this part and then get bitten when they want to restore data.
Posted by: aron_chappel 3 years ago
White Belt
0

As backup is not available then, you need to find the main reason of database corruption, If it is non clustered index then, you can drop and rebuild it. If it is clustered index then, you need to repair it. 

You can repair the database using DBCC CHECKDB repair options. Before running dbcc checkdb repair allow data loss, you need to set the database into Emergency and  single user mode. 

ALTER DATABASE  dbName  SET  EMERGENCY

ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CHECKDB (dbName, REPAIR_ALLOW_DATA_LOSS)

Note: DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS may help you fix all the errors and repair them; however, it can cause data loss from the repaired database.

If you want to bypass all these steps and do not want to lose your data then, you can try SQL recovery software. Stellar Repair for MS SQL is recommended by SQL database admins and experts globally to repair and restores corrupt SQL database. Read more about the software from here: https://www.stellarinfo.com/sql-recovery.php

Posted by: micuki 6 years ago
White Belt
0
more sites info:
https://www.invertia.com/es/foros/-/message_boards/message/139416050
https://onmogul.com/products/el-trasero-de-mi-hermana
https://onmogul.com/products/don-francisco
https://onmogul.com/products/viaje-de-placer-familiar
http://www.pearltrees.com/micuki/item203201175
http://www.pearltrees.com/micuki/item203201530
http://www.pearltrees.com/micuki/item203201646
http://www.pearltrees.com/micuki/item203201745
https://www.webhostingdiscussion.net/forums/index.php/topic,31335.0.html
https://www.webhostingdiscussion.net/forums/index.php/topic,31336.0.html
http://freespaceway.com/ninfomanas/dedeando-a-mi-prima/
http://freespaceway.com/ninfomanas/mi-sobrina-politica/
http://freespaceway.com/ninfomanas/la-bodega/
http://freespaceway.com/ninfomanas/marta-la-sumisa/
http://freespaceway.com/ninfomanas/mi-hermano-marcos/
Posted by: Danishtj 1 year ago
Yellow Belt
0

This article will describe the detailed steps to fix SQL Database in Recovery Mode with different methods. It also includes the primary cause behind the SQL Database stuck in Recovery Mode. However, if these recovery processes fail to fix this recovery mode issue, use SQL Database Recovery Tool to regain access to the database.

Posted by: Danishtj 2 years ago
Yellow Belt
0

SQL Database Recovery is a comprehensive Windows-based product that performs seamless recovery in no time and recovers crucial data from corrupted MS SQL database files. The utility successfully restored SQL database objects without any hassle. The SQL Database recovery software can easily repair and recover corrupt MDF as well as NDF file extensions without harming the original data. 

Download Now: https://www.sysinfotools.com/recovery/ms-sql-database-recovery.php

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ