Solved

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

Posted on 2003-11-10
6
765 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
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 125 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Question 5 28
Sql Join Problem 2 33
Sql Query 4 16
TSQL - 'WHILE EXIST' loop and LIKE % operator 4 0
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

867 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now