Question about Computers & Internet
How to recover a database sql server 2000 with corrupted .mdf file showing suspect mode
Hi..U can get info here:
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:
Posted on Dec 03, 2014
Perform following steps to recover sql server database:
ALTER DATABASE [RdmStoreInformation] SET EMERGENCY
ALTER DATABASE [RdmStoreInformation] SET SINGLE_USER
DBCC CHECKDB ([RdmStoreInformation], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [RdmStoreInformation] SET MULTI_USER
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
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
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
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
Posted on Jan 02, 2017
Tips for a great answer:
Apr 25, 2015 | Microsoft SQL Server 2005 Enterprise...
Nov 28, 2014 | Microsoft SQL Server 2000 Standard Edition...
Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...
Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
May 06, 2014 | Microsoft Database Software A5K-02817 SQL...
Apr 17, 2014 | Computers & Internet
Apr 07, 2014 | Computers & Internet
435 people viewed this question
Usually answered in minutes!