?
Solved

unable to start 6.5 services on nt4 error 1105, event id 17060

Posted on 2003-11-10
6
Medium Priority
?
772 Views
Last Modified: 2012-05-05
hi i have  6.5 sql on nt 4 trying to get the services started to restore a db but upon starting the sqlserver service i get a event id 17060, it says in log file that it cant allocate spae for syslogs, failed to create tempdb , error 1105

and in the service window when you try to start the service it fails and a dialog pops up with error, event id 2140

?any ideas?
0
Comment
Question by:gliceas
  • 3
4 Comments
 
LVL 7

Expert Comment

by:Makr_Watson27
ID: 9714887
You have got enough space on the partition SQL is installed on, i.e. the drive where the tempdb resides
0
 

Author Comment

by:gliceas
ID: 9718321
no there is plenty of space 234mb
0
 
LVL 7

Accepted Solution

by:
Makr_Watson27 earned 500 total points
ID: 9718820
Have you tried the following article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;199364

If you're not already then get the latest service pack for SQL 6.5 as there is a similar issue in SP1 resolves:
http://support.microsoft.com/default.aspx?scid=kb;en-us;153096&Product=sql

Also worth reading:
http://support.microsoft.com/default.aspx?scid=kb;en-us;110139&Product=sql
0
 
LVL 7

Expert Comment

by:Makr_Watson27
ID: 10191651
gliceas: How did you get on with this?  Were any of the links useful?
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question