if you do sp_who, does your select query show as being blocked? Sounds like there is some uncommitted update still open on that table.

Your format file doesn't really match your data. The data you are importing is all character with no data lengths. You also have 4 decimal place numbers you...

Yes. Find out how much data/time your company can afford to lose and take full backups within that window. Without a backup you can lose ALL your data...

There shouldn't be anything special for you to do. SQL Server will compress the data as necessary as it performs the inserts. It manages all the compression so...

Is there an OS paging file on this drive?

I've seen this happen when the file was a single-byte encoded file but was saved as Unicode. Open the file and save it as non-unicode and try it again.

Do you see any blocking on the server? Are you running Express edition? if you issue a checkpoint manually does it come back with an error?

And the DB and log files are set to 'Unrestricted growth'?

My concern would be that if the non-clustered indexes were rebuilt, then the clustered index was rebuilt, the non-clustered indexes might get re-fragmnted based on the movement of rows in...

What order are you defragmenting them? Clustered first then non-clustered? Does the table have any of the disallowed index types or large object data types?

What are the names of the files you have left? Does the SQL Server start? What error messages are you getting? Are all the logins still intact?...

Just some random thoughts:

Check the disks for contention

Check to see if anything else is running on the box and consuming inordinate CPU and/or memory

Make sure your anti-virus software isn't on...

Maybe this is just one of those persistent myths, or maybe I learned this from someone who didn't really know, but in the select/update scenario when incrementing a value, shouldn't...

What's the largest data value you are trying to convert? The Informix type may need to be INT8 in order to handle it.

http://www.ehow.com/info_8738720_informix-data-types.html

Change format file to recognize the 3rd column:

9.0

3

1 SQLCHAR 0 0 "^" 1 RollNo ""

2 SQLCHAR 0 0 "^" 2 Location ""

3 SQLCHAR 0 0 "\r" 3 RollDt ""