?
Solved

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

Posted on 2003-11-10
6
Medium Priority
?
770 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

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 article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

765 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