Issue with storing information

[mteltech]

I have attached a screenshot of an error I am getting with my SQL database. Anyone familiar with this error?

 

[gmmastros]

Basically, the error is:

'TEMPDB' Default FileGroup is full

This means SQL Server could not allocate more space for the tempdb (which is a system database). There are a couple reasons for this error.

Most databases are configured to auto grow. Growing a database is kinda slow, especially for larger databases. So, some people configure the database for a 'relatively' large size and don't let it autogrow.

If your database is configured to autogrow, it could also mean that there is no more space on the physical disk where this database is stored on.

TempDB is used sporadically throughout your SQL Code. But, by definition, it is a temporary database used to hold data, well.... temporarily. When you restart your SQL Service, TempDB is basically deleted and re-created. If your SQL server hasn't been restarted in a long time, this may be your quickest fix for the problem. Re-booting usually only takes a couple minutes. Of course, nobody will be able to access the server during that time, so re-booting may not be an option.

Do you have access to the server that your database is on? What level of access do you have?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mteltech]

I have administrative access to everything. I actually had trouble with the backup last night and restarted the server so I am highly doubtful that this will help. When I restarted it last night I did have an error regarding the services to the backup at login (the original error with the machine) and so I had to manually restart the services to the backup, if this helps any.

 

[gmmastros]

Run this in a query window and post the output here.

sp_helpdb 'TempDB'

Also... how much disk space do you have for the drive that the database is on? You can tell the drive based on the output of the code above.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mteltech]

Here you go. By the way I looked into the actual drive capacity and I see that we are running dangerously low. I will look to resolve this and see if it is the issue.

 

[gmmastros]

One more (if you don't mind):

Create Table #Temp(FileId Int, GroupId Int, Size Int, MaxSize Int, Growth int, Status Int, Perf Int, Name VarChar(100), Filename VarChar(1000))

exec sp_msforeachdb 'Insert Into #Temp Select * from [?]..sysfiles'

Select * From #Temp Order By size DESC
Drop Table #Temp

Run the code above and post the results.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mteltech]

It seems that there is a log clogging up this drive. As I recall when I set it up my intention was to have all the data stored on the F: drive and leave the applications run on the C: It seems that this log is piling up but I cannot seem to find it, just its traces.

Attached is the query you requested.

 

[gmmastros]

I think you attached to wrong image. It's the same as a previous image.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mteltech]

Sorry it is .jpg not .bmp

Figured you were getting tired of the old bitmap.

 

[gmmastros]

There's a couple things I would like to comment on.

First... you have northwind and pubs. These are sample databases distributed by microsoft. You should consider dropping them.

Next... Your largest file is a log file. There are times when a log file can/should be pretty large. In your case, the log file is approximately 9 times larger than the data file. This is usually a good indication that you are using a full recovery model, but you're not backing up your log file. Anyhow, I would encourage you to backup your log file and then shrink it.

Also... your MSDB database seems really large. I encourage you to read this:

http://www.mssqltips.com/tip.asp?tip=1727

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom