Solved

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

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

785 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