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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-12-28 : 21:55:43
|
| In the production we have only one primary file group for TEMP DBname fileid filename filegroup size maxsize growth usagetempdev 1 D:\TempDB\tempdb.mdf PRIMARY 4086976 KB Unlimited 10% data onlytemplog 2 D:\TempDB\templog.ldf NULL 181184 KB Unlimited 10% log onlytempdev_1 3 D:\TempDB\tempdev_1.ndf PRIMARY 3715392 KB Unlimited 10% data onlytempdev_2 4 D:\TempDB\tempdev_2.ndf PRIMARY 3715392 KB Unlimited 10% data onlytempdev_3 5 D:\TempDB\tempdev_3.ndf PRIMARY 3715392 KB Unlimited 10% data onlyBut i am getting the error of :temp DB log file is full.Please help me in this regard.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2011-12-28 : 22:00:56
|
| this is the error message i am getting:Msg 1101, Level 17, State 10, Line 1Could 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, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.Msg 9002, Level 17, State 4, Line 1The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databasesMsg 1105, Level 17, State 2, Line 1Could not allocate space for object 'dbo.SORT temporary run storage: 140737922596864' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.Thanks,Gangadhara MSSQL Developer and DBA |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Temp DB log full Error.