May 14, 2013 at 5:02 am
if Temp Db full which databases will go Offline?
May 14, 2013 at 5:32 am
No databases will go offline. It wil generate error level 17 messages stating "object xx can't be created in filegroup yy for database TempDB" and the transaction(s) will be cancelled and rolled back.
May 14, 2013 at 8:22 pm
HanShi (5/14/2013)
No databases will go offline. It wil generate error level 17 messages stating "object xx can't be created in filegroup yy for database TempDB" and the transaction(s) will be cancelled and rolled back.
Unless it happens during a restart. If tempdb does not have enough space to growth, SQL won't start.
May 14, 2013 at 10:59 pm
HanShi (5/14/2013)
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
I absolutely love that quote.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 14, 2013 at 11:59 pm
Jeff Moden (5/14/2013)
HanShi (5/14/2013)
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **I absolutely love that quote.
Thanks Jeff.
And especially on the internet this is a phrase to live by! :w00t:
May 15, 2013 at 12:55 am
sql-lover (5/14/2013)
HanShi (5/14/2013)
No databases will go offline. It wil generate error level 17 messages stating "object xx can't be created in filegroup yy for database TempDB" and the transaction(s) will be cancelled and rolled back.Unless it happens during a restart. If tempdb does not have enough space to growth, SQL won't start.
If TempDB cannot be recreated, SQL will not start. That would required that someone shuts down SQL, deletes the tempDB files and then does something to fill the disk before restarting SQL. Otherwise the TempDB files will already exist at the time of startup (and they're not grown during the startup process, they're set back to their initial size)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply