I have a table (670 million rows) with 200gb on 272 GB drive with clustered index (PK) and another nonclustered index .
I am trying to move the table to another drive which has capcity of 300gb.
I created another Tmp_tablename on the 300gb drive and started inserting rows from original table.
But the problem is I am running out of space on logfile drive ( logfile drive size 400gb and contains only one logfile on that drive) and the database is in simple mode.
krishnaprasad