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 |
|
velvettiger
Posting Yak Master
115 Posts |
 Posted - 2009-07-07 : 14:30:36
|
Hi ya guys,I was running a query and I got the below error Server: Msg 9002, Level 17, State 6, Line 1The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.How do I go about fixing this. I tried the following code and it did not workBACKUP LOG Barbados_Datamine WITH TRUNCATE_ONLY |
|
|
velvettiger
Posting Yak Master
115 Posts |
Posted - 2009-07-07 : 15:24:18
|
| Okay so I am now getting the following error Server: Msg 1101, Level 17, State 10, Line 1Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.Any ideas |
 |
|
|
xrum
Yak Posting Veteran
87 Posts |
Posted - 2009-07-07 : 15:54:08
|
| http://www.dbforums.com/microsoft-sql-server/998880-could-not-allocate-new-page-database-tempdb.html |
|
|
|
|
|
|
Error Mesage 'tempdb' is full