473,326 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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?
May 24 '15 #1

✓ answered by 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.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.

Helpful resources to explain another methods of restoration and gave more variants of sql data recovery...

https://social.technet.microsoft.com...ssdsgetstarted
http://www.filerepairforum.com/forum...on-on-sql-2014

2 1763
computerfox
276 100+
How is it "corrupt"?
Are you getting an error message?
Is it data-related?
Can you open the database at all?
May 24 '15 #2
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.

Helpful resources to explain another methods of restoration and gave more variants of sql data recovery...

https://social.technet.microsoft.com...ssdsgetstarted
http://www.filerepairforum.com/forum...on-on-sql-2014
May 26 '15 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: aaj | last post by:
Hi all I have been given a corrupt access 2000 backend and asked to salvage the data.(youve gussed it, no backup) On trying to open it just kicks me out saying its not a valid database file -...
1
by: Shannon Rotz | last post by:
I have an Access XP database which just decided to corrupt, with 3 days' worth of brand-new coding in it. The regular "compact and repair" function hasn't worked in this case, and I've tried...
7
by: Steve | last post by:
Hi Can anyone help with the following: I try open an Access 2002 Database, I get a message that the database needs to be repaired as it was not closed properly, I select the option to repair...
4
by: Andy Davis | last post by:
Is it possible to create a button with code to carry out the a weekly compact and repair of database and backup? My users know how to do this from the menu but would really like some kind process...
1
by: Venkatesha R | last post by:
Hi, How to compress and repair access database in c#.net ? Please specify the dll's which are necessary to do these opertions. Thanks, venkatesha R
5
by: Jeff | last post by:
I'm sorry if I am appearing noobish, but I'm a C programmer that inhereted access because I'm the only "computer guy" in the office. Now I've found some problems that I fear maybe a corrupt...
3
by: JensT | last post by:
Help My database acts very strange I have a table named T1. (And a lot of other Tables, queries etc.) Here my database works fine. Then I renamed a table from T1 to T1_imp, and created a...
2
by: wassimdaccache | last post by:
Hy to all I'm using access 2003 (11.5614.5606) I have a database called "form" that I imported all my forms on it and I linked tables of "forms " into another database called "tables" what...
4
by: zufie | last post by:
When I Repair/Compact my Access databse. I get icons/copies of a database named db1.mdb, db2.mdb, db3.mdb, etc... How else may I repair this database? Thanks!, Zuf
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.