Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ish
Starting Member
11 Posts |
 Posted - 2011-02-23 : 20:34:24
|
| Hi I am using Microsoft SQL Server Express 2008. It is running on Windows XP Pro, with 10Gig hard disk free space and 3gig RAM.I installed SQL Server Express 2008 about one month ago. It was working fine till last night. When I try to switch on sql server through service. I am getting following error ;service-specific error code 1814I am lost here. Why suddently stop working. Please could some help me. I have working database and I don't want to loose it.many thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-02-24 : 19:56:14
|
| Can you start SQL as an application? See if the startup switch -f helps:http://msdn.microsoft.com/en-us/library/ms162819.aspx--------------------------------------------------------------------------------What is the contents of the ERRORLOG file? It is generally located in <install path>\Microsoft SQL Server\MSSQL.<Insatance#>\MSSQL\LOG.--------------------------------------------------------------------------------Could this be your issue?1814 = Could not create tempdb. If space is low, extend the amount of space and restart.http://msdn.microsoft.com/en-us/library/aa258778(SQL.80).aspx=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
|
|
|
Getting this message service-specific error code 1