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
a 6ya Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 13, 2015 | Microsoft SQL Server 2005 Enterprise...
Nov 28, 2014 | Microsoft SQL Server 2000 Standard Edition...
Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...
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
433 people viewed this question
Usually answered in minutes!