2 {{ upvoteCount | shortNum }}
2 {{ upvoteCount | shortNum }}

sql database

by aidanmills
2 replies
One of my SQL database corrupt. And i don't have any backup ......i got the biggest prob. i tried to repair will all the 'DBCC' command but none of those works... I tried 'dbcc checkdb', 'dbcc CHECKALLOC', 'DBCC CHECKTABLE' but none of this found any problem. Is there any extra tools or other command to repair MSQL 7.0 Database? Please help please....

In access i always Jet4 repair database command but what should i use in SQL?
#database #sql
  • Profile picture of the author dvduval
    Google misamchk
    Signature
    It is okay to contact me! I have been developing software since 1999, creating many popular products like phpLD.
    {{ DiscussionBoard.errors[10446131].message }}
  • Profile picture of the author baahirfarooq
    Helpful resources to explain other methods of restoration and gave more variants of sql data recovery...
    https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox

    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.mdf'), (FILENAME = ' c:\data files\my_data.ldf') 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.
    {{ DiscussionBoard.errors[10448005].message }}

Trending Topics