Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Error: 1101 Severity: 17

Author  Topic 

Hommer
Aged Yak Warrior

808 Posts

Posted - 2012-12-12 : 08:56:09
Hi,

I started to see these next two alerts I set for myself. However, whereever I checked, there were plenty of spaces. They showed up around back end of some of the scheduled Tlog backups.

What else could cause this? Thanks!

spid58,Unknown,Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'.
Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or
setting autogrowth on for existing files in the filegroup.

spid94,Unknown,Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'.
Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or
setting autogrowth on for existing files in the filegroup.

Hommer
Aged Yak Warrior

808 Posts

Posted - 2012-12-12 : 08:58:14
I also saw: Version store is full. New version(s) could not be added. A transaction that needs to access the version store may be rolled back. Please refer to BOL on how to configure tempdb for versioning.

...
This is sql 2008 r2.
Go to Top of Page

johnson_ef
Starting Member

16 Posts

Posted - 2012-12-12 : 09:42:04

These 2 links have good info related to this.

http://msdn.microsoft.com/en-us/library/ms176029(v=sql.105).aspx
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/10/13/troubleshooting-tempdb-growth-due-to-version-store-usage.aspx

-Johnson
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-13 : 13:54:02
Is Autogrowth enabled?
Go to Top of Page
   

- Advertisement -