SHRINKFILE huh

Use this only when absolutely necessary. You might end up with 1TB defragmetated discs very soon with performance issues instead.

Be careful

I aggre but still if someone for a reason needs to shrink the files as described here.

This may do the trick.

Best practice is to never shrink log files (defragmentated discs...

Hi,

I use this

First of all

BACKUP DATABASE

then

Backup Log

Do this in a normal way and put the files somewhere

Then run

USE Big_VirtualLog_DB

GO

DBCC shrinkfile('database_LogFile',1 )

1 = 1MB

Even if you stated 1 MB...

Nice, thanks

There is an excellent software that can convert DTS packages to SSIS packages from a company called pragmatic works. I have done this recently and it works. I had to...