Question about Computers & Internet

5 Answers

SQL SERVER 2000

How to recover a database sql server 2000 with corrupted .mdf file showing suspect mode

Posted by on

Ad

5 Answers

  • Level 1:

    An expert who has achieved level 1.

    New Friend:

    An expert that has 1 follower.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 1 Answer

Hi..U can get info here:
https://groups.google.com/forum/?hl=en#!topic/sql-mdf-viewer/ocCTaFcKYag

Or do this
· Click the Windows "Start" button and enter "cmd" into the text box. Press "Enter" to open your command line utility.
·Type the following command into the command prompt and press "Enter":
cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
This points the command prompt to the location of the rebuild executable files.
·Type the following text into the command line and press "Enter":
Setup.Exe /Action=RebuildDatabase /InstanceName=MSSQLSERVER /SqlSysAdminAccounts=Admin
This command rebuilds the database. It may take several minutes to complete. Once it is finished, the command line returns a success message.
if nothing helped:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file

Posted on Dec 03, 2014

Ad
  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 39 Answers

Perform following steps to recover sql server database:

  • Create a database with same size that you are trying to recover
  • Shutdown the SQL server
  • Swap old mdf file with new mdf file
  • Start the SQL server
  • Database may go in suspect
  • Set database in emergency mode
  • Run DBCC CHECKDB with repair_allow_data_loss to repair database


USE [master]
GO
ALTER DATABASE [RdmStoreInformation] SET EMERGENCY
GO
ALTER DATABASE [RdmStoreInformation] SET SINGLE_USER
GO
DBCC CHECKDB ([RdmStoreInformation], REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE [RdmStoreInformation] SET MULTI_USER
GO
ALTER DATABASE [RdmStoreInformation] SET ONLINE


It may result some data loss. If you don't want to lose any single data then use 3rd party SQL repair software from Stellar Phoenix.

Posted on Jan 18, 2013

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.

  • Expert
  • 43 Answers

Dbcc checkdb('DB-NAME',REPAIR_ALLOW_DATA_LOSS) command may cause data loss. So it is better to use third party tool like: SQL MDF Repair Tool

Posted on Jun 20, 2016

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Computers & ... Expert
  • 416 Answers

Recover .mdf file you may with the help of programming way.
You need to software recovering .sql databases of any version SQL Server. I would recommend you to try tool below
sql server fix

Posted on Apr 30, 2012

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 41 Answers

Have you tried out the old way of creating empty database with same name.
Stop sql server
Paste database at the same location ...
And restart the server ....

Posted on Mar 19, 2008

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

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

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

Recover data from corrupt .mdf and .ldf files.


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/

Nov 28, 2014 | Microsoft SQL Server 2000 Standard Edition...

7 Answers

Any Powerful SQL repair tool with new features


Hi Mahi,

If you are looking for any Powerful SQL Repair Tool then I would recommend you to use SQL Database Recovery Software by Aryson.

This tool can recover and repair all your MDF files with attachments.

Hope This Helps !!




62382637-51ff-4f85-9510-b7f9091aae51.png

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...

7 Answers

How to recover SQL server mdf files?


RecoveryFix for SQL database recovery software is recover and repair MDF files components from corrupted SQL server database. This software compatible with Windows 7, Server 2008, Vista, Server 2003, XP and 2000. More details see this site: http://www.en.repairsqlserver.net/ or download this tool from http://www.en.repairsqlserver.net/free-trial.html

May 06, 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

6 Answers

SQL Server Database Recovery Software - How to Recover MDF File?


You can try to use RecoveryFix for SQL database recovery software to retrieve your lost and corrupted data from SQL server. For more details about this software: http://www.sqlrecovery.org/
See demo: https://www.youtube.com/watch?v=Q0aW1vT5nxA

Apr 07, 2014 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

435 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...