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.
| 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. |
 |
|
|
johnson_ef
Starting Member
16 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-13 : 13:54:02
|
| Is Autogrowth enabled? |
|
|
|
|
|
|
Error: 1101 Severity: 17