Repair Corrupt Database?

[stanleypowell]

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?

[computerfox]

How is it "corrupt"?
Are you getting an error message?
Is it data-related?
Can you open the database at all?

[calvincooley]

Restore With Transact-SQL

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

-Click in the text area and type a Create Database statement using the following Transact-SQL code as a guide:
CREATE DATABASE MyDatabase ON (FILENAME = 'c:\data files\my_data.m df'), (FILENAME = ' c:\data files\my_data.l df') FOR ATTACH;

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

Helpful resources to explain another methods of restoration and gave more variants of sql 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