Correction...I am sure I typed the DBCC SHRINKFILE command, don't know why it did not show up - but here it is again:

DBCC SHRINKFILE(, file_size_in_MB)

Instead of stopping SQL Server, there are other options you can take.

Before the next run of the data run (that increases the log file to fill up the disk), ensure...

Agreed about transactions being lost that have been written to log file but not to data files. Yes, you would lose them if the log was rebuilt without the transactions...

Sorry, I just saw the issue was resolved...:))

Hi splatt,

Just a quick question - was your sever's "Recycle Bin" configured to delete files immediately? If not - you can probably still look in there to see if the...