• Interesting question about I never used thru T-SQL.

    I discovered the WITH NORECOVERY when I tested how to backup with SMO ( there is an option which permits to visualize the T-SQL code generated thru a SMO application without executing it : useful to test it )