• great article from Chris Kempster!

    I like his approach of divide into 3 methods with t/sql code.

    It is quite useful for my environment, since most files are < 2 gb due archiving periodically.

    I did not know that there is a way to take a database off-line with [exec sp_dboption N'mydb', N'offline', N'true'].

    thanks

    -D