Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using SQL Server 2008 R2 with Windows XP Professional with SP3 on my PC for development.

I've noticed that during the last 6 months the SQL Server crashes and is corrupted again and again. What could be the reason? Is it possible the problem is Windows XP?

I have tried the following:

  • Installing SQL Server Service Packs one by one. Installing Windows XP Server Service Packs one by one.

  • Tried different combinations of Service packs

  • Only installed database, not reporting services etc.

I have used SQL Server 2005 and 2000 for many years and never had such a problem.

share|improve this question
    
What's in the event log? –  ta.speot.is Feb 3 '13 at 11:06
    
nothing special, normally it cannot start MSSQLSERVER service. and if I try to start it manually, ends up giving error msg like cannot find SQL server or timeout –  Raza Feb 3 '13 at 11:42
    
The event log usually has a reason as to why the service cannot start. SQL Server also has other logs. –  ta.speot.is Feb 3 '13 at 11:45
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.