I have Microsoft Office Accounting running on an SBS 2003 Premium Server (with full SQL Server 2005).
I am having a problem with the TempDB file which I believe is running out of space.
As this is the SQL group, I won't go into the Office Accounting side of things, however I tried to create a sample company to see if that would work. The error I get there is:
===
2009-01-06 14:30:50.64 spid56 Starting up database 'SampleServiceCompany2008'
.
2009-01-06 14:30:50.96 spid56 Setting database option AUTO_CLOSE to OFF for database SampleServiceCompany2008.
2009-01-06 14:30:57.93 spid56 Error: 1105, Severity: 17, State: 2.
2009-01-06 14:30:57.93 spid56 Could not allocate space for object 'dbo.Large Object Storage System object: 450437288820736' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
===
I have also had this error when doing it:
===
009-01-06 14:26:50.43 spid56 Starting up database 'SampleServiceCompany2008'
.
2009-01-06 14:26:50.79 spid56 Setting database option AUTO_CLOSE to OFF for database SampleServiceCompany2008.
2009-01-06 14:26:56.92 spid56 Error: 17053, Severity: 16, State: 1.
2009-01-06 14:26:56.92 spid56 D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\
tempdb.mdf
: Operating system error 112(error not found) encountered.
===
I ran an sp_spaceused on TEMPDB with the following results:
===
database_name - TEMPDB
database_size - 11.44MB
unallocated space - 8.47MB
reserved - 1184KB
data - 512KB
index_size - 592KB
unused - 80KB
===
I'm not sure I understand this.
TEMPDB was set for 10% and Autogrow. I read somewhere that perhaps it was growing it fast enough to keep up with MOA so I set it to 10Mb and Autogrow but that resulted in immediate errors rather than it trying for a while and then failing.
I then set it to 20% and autogrow - same problem.
I have finally gave it an initial size of 20Mb for the database and 5Mb for the Log. When I did that I got an error "112 (error not found) while trying to expand the physical file". Error 112 looks like insufficient disk space (from some Googling). The C: drive has 6Gb free and the D: drive (where the TEMPDB database resides) has 68Gb free.
I'm very confused! Help?
I am not a SQL person, so if you have any suggestions please outline how I carry them out (as a lot of the SQL stuff I've read in forums while researching this kind of suggests you know exactly where sys.database is etc. - I don't :-))
