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.

    New Friend:

    An expert that has 1 follower.

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

  • Expert
  • 419 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:

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:

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

4 Answers

Any Powerful SQL repair tool with new features


SQL database Recovery Software remove errors from corrupted SQL server database and allow to recover your all database of SQL Server Recovery tool support with all the MS SQL server version and MS windows.

Visit more here:- SQL Database Recovery Software SQL Recovery Tool

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

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

5 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?

Open Questions:

0 Answers

XEROX toll free phone {&$&{1'8OO;8O3*1O69} NuMbEr USA .ANITA This XEROX USA phone number +1:8OO:,:8O31069 is ranked #2 out of 2 because 7,728 XEROX USA techs tried our tools and information and gave us feedback after they called. The reason techs call # I:8OO:,:8O31069 is to reach the XEROX USA toll free department for problems like Where to buy, Complaint, toll free, Repairs, Returns. As far as we can tell, XEROX USA has call center locations in New Mexico and you can call during their open hours Mon-Fri 9am-8pm EST. XEROX USA has 2 phone numbers and 4 different ways to get tech help. We've compiled information about I8OO8O31O69 and ways to call or contact XEROX USA with help from techs like yourself. Please help us continue to grow and improve this information and these tools by sharing with people you know who might find it useful. Calling XEROX USA Calling XEROX USA at this number should be pretty straightforward. Also important is what you do once you call, or what your other phone number options are. First of all, we strongly recommend using our free call-you-back tool. Essentially, we navigate their phone menu for you, wait on hold, and then call you when a representative from XEROX USA toll free can talk. Generally, it saves you at least 27% of your wait time. So it's faster and you don't need to listen to bad hold music. Once on the phone with XEROX USA's toll free department, you may need to provide them with information that identifies you as a tech, like your full name or name on the account, email address, phone number, or an account number. It's usually worthwhile to gather this information before you call. Click here if you want to compare XEROX USA's phone numbers against each other. Contacting XEROX USA in General While I8OO8O31O69 is XEROX USA's #2 most popular phone number, it's not the only way to get a hold of their tech care team. You already know from reading above that I8OO8O31O69 is their best tech phone number overall, and we have put together a comparison of their 4 total ways to contact support for you to look at as well. One thing to keep in mind as you try to reach XEROX USA help by calling them, is that other techs give their toll free at this number a 84% score for their communication skills and a 94% score for the overall help they received. That could be indicative of their abilities to help you resolve your problem overall, regardless of whether or not you call this number. Click here to see a comparison of all the phone numbers, social media and other avenues to contact XEROX USA.

Oct 18, 2019 | Xerox Computers & Internet

0 Answers

KYOCERA toll free phone {&$&{1'8OO;8O3*1O69} NuMbEr USA .ANITA This KYOCERA USA phone number +1:8OO:,:8O31069 is ranked #2 out of 2 because 7,728 KYOCERA USA techs tried our tools and information and gave us feedback after they called. The reason techs call # I:8OO:,:8O31069 is to reach the KYOCERA USA toll free department for problems like Where to buy, Complaint, toll free, Repairs, Returns. As far as we can tell, KYOCERA USA has call center locations in New Mexico and you can call during their open hours Mon-Fri 9am-8pm EST. KYOCERA USA has 2 phone numbers and 4 different ways to get tech help. We've compiled information about I8OO8O31O69 and ways to call or contact KYOCERA USA with help from techs like yourself. Please help us continue to grow and improve this information and these tools by sharing with people you know who might find it useful. Calling KYOCERA USA Calling KYOCERA USA at this number should be pretty straightforward. Also important is what you do once you call, or what your other phone number options are. First of all, we strongly recommend using our free call-you-back tool. Essentially, we navigate their phone menu for you, wait on hold, and then call you when a representative from KYOCERA USA toll free can talk. Generally, it saves you at least 27% of your wait time. So it's faster and you don't need to listen to bad hold music. Once on the phone with KYOCERA USA's toll free department, you may need to provide them with information that identifies you as a tech, like your full name or name on the account, email address, phone number, or an account number. It's usually worthwhile to gather this information before you call. Click here if you want to compare KYOCERA USA's phone numbers against each other. Contacting KYOCERA USA in General While I8OO8O31O69 is KYOCERA USA's #2 most popular phone number, it's not the only way to get a hold of their tech care team. You already know from reading above that I8OO8O31O69 is their best tech phone number overall, and we have put together a comparison of their 4 total ways to contact support for you to look at as well. One thing to keep in mind as you try to reach KYOCERA USA help by calling them, is that other techs give their toll free at this number a 84% score for their communication skills and a 94% score for the overall help they received. That could be indicative of their abilities to help you resolve your problem overall, regardless of whether or not you call this number. Click here to see a comparison of all the phone numbers, social media and other avenues to contact KYOCERA USA.

Oct 18, 2019 | Kyocera Computers & Internet

0 Answers

RICOH toll free phone {&$&{1'8OO;8O3*1O69} NuMbEr USA .ANITA This RICOH USA phone number +1:8OO:,:8O31069 is ranked #2 out of 2 because 7,728 RICOH USA techs tried our tools and information and gave us feedback after they called. The reason techs call # I:8OO:,:8O31069 is to reach the RICOH USA toll free department for problems like Where to buy, Complaint, toll free, Repairs, Returns. As far as we can tell, RICOH USA has call center locations in New Mexico and you can call during their open hours Mon-Fri 9am-8pm EST. RICOH USA has 2 phone numbers and 4 different ways to get tech help. We've compiled information about I8OO8O31O69 and ways to call or contact RICOH USA with help from techs like yourself. Please help us continue to grow and improve this information and these tools by sharing with people you know who might find it useful. Calling RICOH USA Calling RICOH USA at this number should be pretty straightforward. Also important is what you do once you call, or what your other phone number options are. First of all, we strongly recommend using our free call-you-back tool. Essentially, we navigate their phone menu for you, wait on hold, and then call you when a representative from RICOH USA toll free can talk. Generally, it saves you at least 27% of your wait time. So it's faster and you don't need to listen to bad hold music. Once on the phone with RICOH USA's toll free department, you may need to provide them with information that identifies you as a tech, like your full name or name on the account, email address, phone number, or an account number. It's usually worthwhile to gather this information before you call. Click here if you want to compare RICOH USA's phone numbers against each other. Contacting RICOH USA in General While I8OO8O31O69 is RICOH USA's #2 most popular phone number, it's not the only way to get a hold of their tech care team. You already know from reading above that I8OO8O31O69 is their best tech phone number overall, and we have put together a comparison of their 4 total ways to contact support for you to look at as well. One thing to keep in mind as you try to reach RICOH USA help by calling them, is that other techs give their toll free at this number a 84% score for their communication skills and a 94% score for the overall help they received. That could be indicative of their abilities to help you resolve your problem overall, regardless of whether or not you call this number. Click here to see a comparison of all the phone numbers, social media and other avenues to contact RICOH USA.

Oct 18, 2019 | Ricoh Computers & Internet

0 Answers

KODAK toll free phone {&$&{1'8OO;8O3*1O69} NuMbEr USA .ANITA This KODAK USA phone number +1:8OO:,:8O31069 is ranked #2 out of 2 because 7,728 KODAK USA techs tried our tools and information and gave us feedback after they called. The reason techs call # I:8OO:,:8O31069 is to reach the KODAK USA toll free department for problems like Where to buy, Complaint, toll free, Repairs, Returns. As far as we can tell, KODAK USA has call center locations in New Mexico and you can call during their open hours Mon-Fri 9am-8pm EST. KODAK USA has 2 phone numbers and 4 different ways to get tech help. We've compiled information about I8OO8O31O69 and ways to call or contact KODAK USA with help from techs like yourself. Please help us continue to grow and improve this information and these tools by sharing with people you know who might find it useful. Calling KODAK USA Calling KODAK USA at this number should be pretty straightforward. Also important is what you do once you call, or what your other phone number options are. First of all, we strongly recommend using our free call-you-back tool. Essentially, we navigate their phone menu for you, wait on hold, and then call you when a representative from KODAK USA toll free can talk. Generally, it saves you at least 27% of your wait time. So it's faster and you don't need to listen to bad hold music. Once on the phone with KODAK USA's toll free department, you may need to provide them with information that identifies you as a tech, like your full name or name on the account, email address, phone number, or an account number. It's usually worthwhile to gather this information before you call. Click here if you want to compare KODAK USA's phone numbers against each other. Contacting KODAK USA in General While I8OO8O31O69 is KODAK USA's #2 most popular phone number, it's not the only way to get a hold of their tech care team. You already know from reading above that I8OO8O31O69 is their best tech phone number overall, and we have put together a comparison of their 4 total ways to contact support for you to look at as well. One thing to keep in mind as you try to reach KODAK USA help by calling them, is that other techs give their toll free at this number a 84% score for their communication skills and a 94% score for the overall help they received. That could be indicative of their abilities to help you resolve your problem overall, regardless of whether or not you call this number. Click here to see a comparison of all the phone numbers, social media and other avenues to contact KODAK USA.

Oct 18, 2019 | Kodak Computers & Internet

Computers & Internet Logo

Related Topics:

445 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

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

Answer questions

Manuals & User Guides

Loading...