Solved

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

Posted on 2003-11-10
6
761 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
Comment Utility
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
Comment Utility
no there is plenty of space 234mb
0
 
LVL 7

Accepted Solution

by:
Makr_Watson27 earned 125 total points
Comment Utility
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
Comment Utility
gliceas: How did you get on with this?  Were any of the links useful?
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

743 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