November 6, 2008 at 1:06 pm
Clearing tempdb database.
Error: 5171, Severity: 16, State: 1.
f:\MSSQL.1\MSSQL\LOG\tempdb.mdf is not a primary database file.
Error: 1802, Severity: 16, State: 4.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
November 6, 2008 at 1:10 pm
Is there a question here? You need more disk space.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 6, 2008 at 2:03 pm
Did you do anything to the tempdb files? Did you copy then anywhere, rename anything or anything like that. Basically, what did you do to the server between the time SQL was shut down and the time that you restarted it.
f:\MSSQL.1\MSSQL\LOG\tempdb.mdf is not a primary database file.
Indicates that one of the tempdb files isn't valid. Are there any other messages in the error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 2:31 pm
I did nothing. The only thing is that we changed autentication from mixed to Windows only. Then we tried to restart the server. What I s interesting is that I noticed tempdb mdf and ldf files yesterday were on E drive. But when we tried to restart they were created in F drive.
November 6, 2008 at 2:44 pm
Someone must have altered them somehow and not restarted the server. Were there any trace flags set on the service startup?
You can move the files back using the process here: http://support.microsoft.com/kb/224071
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 6, 2008 at 2:57 pm
Does the path F:\MSSQL.1\MSSQL\LOG\ exist?
If so, what files are in there?
Are there any other errror relating to tempDB or Model in the error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 7, 2008 at 7:16 am
Hi, thank you for trying to help. The path exists, the files there are tempdb.mdf and tempdbldf. Also there is a lot of space available there.
November 7, 2008 at 8:01 am
I will try to do it. I have to change start up params or sql server to be in single user mode and restore only master db. Then look at tempdb mdf and ldf or move them or increase the size.
Then change again startup params back to what it was and try to restart sql server again
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply