INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I posted a query a short while ago and had an informed answer within a couple of hours. Terrific!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Setup and Administration Forum

uninstalling\reinstalling SQL Server 2005

Read More Threads Like This One

TiltingCode (Programmer)

20 May 12 12:00

Over a year ago I installed SQL Server 2005 Developer Edition on my laptop with Windows 7. For some reason SQL Express also go installed which is part of the issues I'm having. Whenever I try to do anything sometimes it expects SQL and other times SQL Express.

Because I'm so smart I stopped SQL Express in the SQL Server Configuration Manager and then I was informed not to do that so I tried to start it again and it fails every time. I get a "request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." message.

I backed up my database (I think) to a ldf and mdf file.

So.... here are my questions\concerns: Do I have to uninstall SQL2005 and reinstall? If so will these files completey restore my database and everything else? Or is there a way to get SQLEXPRESS started again?

SQLBill (MIS)

24 May 12 10:48

First, you probably aren't going to get many responses because you 'tagged' this thread as an 'idea' (the light bulb) not a question.

You can't backup a database to a .mdf/.ldf. Those are the data and log files. If the database was detached, then you could make a backup of those files and they would be usable. If the database was in use, any backup of those files will be unusable.

I've never been in the situation you are in, so I'm not sure what the solution is.

However, can you open SQL Server Developer Edition? If you can open up SSMS, I would see if the database exists there. If not, try to attach the existing .mdf/.ldf files. If that works - great. Make a backup of the database and then just uninstall the SQL Express version.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

TiltingCode (Programmer)

25 May 12 5:29

Thanks SQLBill,
I didn't realize it didn't come out as an idea and not a question. I will do as you suggested. It won't be this weekend but I'm looking forward to trying it.

SQLScholar (Programmer)

25 May 12 6:22

Have you checked the windows event log. It should let you know why the service didnt start.

May be due to permissions. If so try changing to local service.

Dan

----------------------------------------
www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft SQL Server: Setup and Administration