• 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