sql database

by 2 replies
2
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?
#programming #database #sql
  • Google misamchk
  • 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.
  • [DELETED]
  • Banned
    [DELETED]
  • Banned
    [DELETED]
Join the discussion

Next Topics on Trending Feed

  • 2

    sql database

    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?