SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 Recover database with mdf and ldf
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

skinch
Starting Member

Canada
4 Posts

Posted - 01/07/2010 :  07:56:15  Show Profile  Reply with Quote
I am running SQL Server 7.0 on a XP box. I am unable to start the SQL Server due to the following error. I do not have a good backup of my database.

Your SQL Server installation is either corrupt or has been tampered with (unknown Package id. Please rerun setup.

I am afraid if I rerun the setup I will screw up my database. Since I don't have a good backup I need to be careful. Any suggestions on how to proceed are welcomed.

Thanks,
Sherry

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 01/07/2010 :  08:39:06  Show Profile  Send rajdaksha a Yahoo! Message  Reply with Quote
Hi

Am not sure its possible in sql server 7.0



In SQL SERVER 2008 read below
First try to change the mode to READ_WRITE. Do it from SSMS or run

ALTER DATABASE MyDatabase SET READ_WRITE

If it fails, then maybe the error message will give you a hint. Also check the MDF/LDF file-level permissions and make sure the account running SQL Server Database Engine has read/write permissions.

Also check the SQL Server ERRORLOG file - it may have more details about the reason


-------------------------
[R][A][J]


Edited by - rajdaksha on 01/07/2010 08:39:33
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/07/2010 :  09:09:57  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Copy the .mdf, .ldf and, if applicable, the .ndf files somewhere safe. Make sure the SQL service is stopped before you do that. Once you have those somewhere safe, try rerunning setup to fix whatever's busted with the servics

--
Gail Shaw
SQL Server MVP
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 05/05/2014 :  01:53:11  Show Profile  Reply with Quote
u don't need to worry about any more because there are many more tools available in online market go through them and download. These free utility will help you to recover your sql server database.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000