Question about Microsoft SQL Server 2000 Standard Edition for PC

4 Answers

Recover data from corrupt .mdf and .ldf files.

Hello. The server was crashed due to some hardware problems. I was able to recover .mdf and .ldf files but when I tried to attach them an error message appears that. I am running MS SQL Server 2000 SP4. Error 5171: path......\.mdf is not a primary database file. I created a new database with the same name stop SQL Service replace newer files with the corrupted one Start SQL Service Now the database is in the suspected mode Changed it to emergency mode executed dbcc checkdb ('dbname') then dbcc dbrecover ('dbname') I have .mdf and .ldf files only.None of the attempt is helpful((. Would appreciate your help and quick response in solving the problem!

Posted by on

Ad

4 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

You can find more information here:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file

Open your SQL Server Management Studio console. This application shortcut is available in the SQL Server directory in the Windows Start button.
· Enter the system administrator user name and password. SQL Server's administrator user name is "sa." This account is required for privileges to restore the database. If your restoring on a host provider server, use the administrator user name and password they supplied for your account.
·Right-click your database name and select "Attach." In the new window that opens, click the "Add" button to open a dialog box.
·Select your MDF file and press the "Ok" button. It may take several minutes to restore the database if it is a large file. Once the process is finished, browse your tables to verify the data. The database is now restored.
If nothing helped try to use:SQL Server Fix Toolbox
http://www.fixsqldatabase.com/

Posted on Dec 01, 2014

Ad
  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

When the corruption occurs in MDF file, you will find some problems like accessibility of data, inability to load or run data, unable to boot and so on. All these happen due to several problems like media malfunction, virus attack, hard drive failure, fire or water damage, unexpected system shutdown and etc.If everything is possible, then SQL Database is also possible. In just few clicks, you can now repair corrupt MDF file and can recover SQL database with advanced SQL Database Recovery is a recognized and accepted solution by a number of users. With this tool, you can repair SQL files and extract database to utilize. It repairs and restores all SQL Server components like tables, functions, stored procedures, views, constraints, triggers and more.

Posted on Jun 13, 2017

Ad
  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Social Spider:

    An expert who has shared 50 answers on their Facebook wall.

  • Microsoft Expert
  • 43 Answers

Take a look at this informative video it shows different methods to fix sql server error 5171

Posted on May 11, 2016

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Cheetah:

    An expert who has answered 20 or more questions within one hour.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 49 Answers

It sounds like you had a system crash. There is nothing you can do.

Posted on Nov 30, 2014

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How do I recover data from .mdf file


Detach you database. Overwrite the mdf and ldf files you've restored from your backup with your files from the D: drive. Reattach the database.
There is no guarantee that this will work or if it works, that your database is in a state where you can continue to work with.
If that doesn't work then there is an option to try to restore database using SQL Server Recovery Toolbox. It is a powerful tool for data recovery. They have a demo version. So you can check it works in your situation or not.
http://www.oemailrecovery.com/sql_repair.html

Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...

7 Answers

Repair a corrupt SQL database in SQL 2005


Known as the leading solution provider in the field of data recovery and data conversions, the company has created a niche for another efficient tool known as SQL Server Repair Toolbox. The MS SQL repair tool reads *.mdf and *.ndf files and saves data, structure, links, etc. as SQL scripts or exports directly to Microsoft SQL Server through direct connect. read more details SQL Server Repair Toolbox

Jun 13, 2015 | Microsoft SQL Server 2005 Enterprise...

2 Answers

Attach a database without the corrupted log file


There might be other options out there. This is something that worked for me once but there are no guarantees that it will work at all times.

Stop SQL Server instance -> Copy MDF and LDF files to another location -> Delete original MDF and LDF files -> Start SQL Server instance again -> Create new database with exact same name and file names -> Stop SQL Server -> overwrite newly created MDF and LDF.

After this your database should be back online. If it is then go ahead and put it into EMERGANCY mode and SINGLE USER mode.

Finally go ahead and execute DBCC CHECKDB like this

DBCC CHECKDB (databaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

More information you can dig out from resources directly connected with SQL Server databases and database corruption in MS SQL Server any version...
http://itknowledgeexchange.techtarget.com/itanswers/how-to-restore-mdf-file-as-bakcup-databe/
https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox

May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...

5 Answers

Import damaged SQL MDF file


I would like to suggest you to use of MDF Repair Kit. An exciting new product from Repair Kit, this MS SQL MDF repair tool is an absolutely indispensable tool for anyone who wants to know how to repair MDF files in minutes. The program is based on a powerful analysis core and uses a convenient wizard-driven UI.

For more: http://www.mdf.repair/

Apr 25, 2015 | Microsoft SQL Server 2005 Enterprise...

4 Answers

Better and safe way to repair and recover MDF files


To choose a reliable and 100% safe and secure, a SQL server database recovery utility guarantee the zero loss of quality. You can refer to this page: http://www.sqlrecovery.org and also read this post http://recoverymaster.livejournal.com/519.html

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

4 Answers

Some great advice for all SQL server user


You should try some MDF file recovery tool if the file is corrupt.

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

16 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

5 Answers

How to recover deleted Microsoft SQL server MDF files?


Recover and repair MDF files with simple and efficetive tool to repair and recover MDF files from corrupt and damaged SQL server, which tool support all king of SQL server version and Windows OS. Visit here: http://www.en.mdfrepair.net
Read blog post: http://exchangerecovery.hubpages.com/hub/How-to-perform-SQL-Database-Recovery Corrupt MDF File Repair Utility

Apr 17, 2014 | Computers & Internet

4 Answers

Whst is the difference between .mdf,.ldf & .sdf?


LDF - layered data file, is the transaction log file for your database. It allows you to roll back changes you made to the data to a particular point and is used in rebuilding the data should it become corrupted.

MDF - Meta data file, is your actual data

SDF - Is a sequential data file, a flat file that can be used for compatibility with MS-SQL server, MySQL, etc.

Dec 03, 2009 | Oracle 10g Database Standard (ODBSEONUPP0)

Not finding what you are looking for?
Microsoft SQL Server 2000 Standard Edition for PC Logo

267 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2885 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18408 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...