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.