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.

All Forums  General SQL Server Forums  New to SQL Server Programming  The Transaction log for the database 'tempdb' is f

Author  Topic  Reemi123 Starting Member 1 Post Posted - 2012-10-03 : 15:34:14 Hi, I just started using SQL server management Studio, i have a database and a table with 498591 records. I have a sql script which remove duplicates. Whilst running the script, 2.5 hours later i get a popup saying space on E:\ is running low. At the end it said query completed with errors, "The Transaction log for the database 'tempdb' is full". I checked the E:\ and it was full, only had 10mb available, E:\ is also where the tempdb file was. What would be the best course of action? I assume i need to rerun the script again as there is still 498591 records.