April 27, 2010 at 7:19 am
SQL Server 2008
10.0.2531.0 SP1Enterprise Edition
I have 8 tempdb data files (1 for each processor)
The other day I noticed that my master MDF file for tempdb was not growing in sync with the other 7 ndf files.
I went into SSMS to shrink the main file; decided to look at some of the other ndf files and received the error: "Input string was not in a correct format. (mscorlib)"
I opened up a query window and executed sp_helpdb tempdb and it shows only two files; the main data file and one log file.
Any suggestions on how to correct this discrepancy? Any idea why this happened?
April 27, 2010 at 7:45 am
That's strange. Have you checked sys.files or checked from another SSMS instance?
April 27, 2010 at 8:22 am
I did. I checked both sysfiles and from my local SSMS and the results were the same.
I don't what happened but I deleted the extra files that showed up on SSMS and added them back using TSQL alter database - add file and it looks like all is right with the world again. Very peculier.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply