|
Reemi123
Starting Member
1 Posts |
 Posted - 10/03/2012 : 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. |
|
The Transaction log for the database 'tempdb' is f
