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?
Answer Summary:
Cancel
2 Comments   [ + ] Show Comments

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/
  • 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
Please log in to comment

Answer Chosen by the Author

1

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

Answered 05/20/2015 by: axtonlindsey
White Belt

Please log in to comment

Answers

This content is currently hidden from public view.
Reason: Member has been banned from the site
For more information, visit our FAQ's.

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

Answered 11/09/2015 by: AldoRoesch
White Belt

Please log in to comment
0
Professional Access Database Repair Tool which can repair corrupt MS Access (.MDB or .ACCDB) database file and then recover tables, queries, forms, macros, reports, etc. See at: http://www.softmagnat.com/access-database-repair.html

Answered 01/09/2016 by: Mariasclarks
Senior White Belt

Please log in to comment
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.
Answered 05/17/2015 by: VBScab
Red Belt

Please log in to comment
This content is currently hidden from public view.
Reason: Spam
For more information, visit our FAQ's.

This content is currently hidden from public view.
Reason: Spam
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity