SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Error: 1101 Severity: 17
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hommer
Aged Yak Warrior

786 Posts

Posted - 12/12/2012 :  08:56:09  Show Profile  Reply with Quote
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

786 Posts

Posted - 12/12/2012 :  08:58:14  Show Profile  Reply with Quote
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.

Edited by - Hommer on 12/12/2012 08:59:54
Go to Top of Page

johnson_ef
Starting Member

India
16 Posts

Posted - 12/12/2012 :  09:42:04  Show Profile  Reply with Quote

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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/13/2012 :  13:54:02  Show Profile  Reply with Quote
Is Autogrowth enabled?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000