The below has worked for me. You can give it a try in your lower environments if it permits.

https://dbamohsin.wordpress.com/category/sql-server/page/16/

Thanks

Thanks this helped.

Nice tip. Thanks for the post.

I agree with the SSC Rookie's post. sp_OAGetProperty is very soon to get deprecated. We shall replace such codes with CLR functions.

Thanks for the article though.

Try BULK INSERT using the arguments: ROWS_PER_BATCH or BATCHSIZE to a min no. of rows and this will reduce the logging as the one batch is treated as one transaction....

Syed,

Your backup size will not increase if the overall data remains more or less the same. Can you throw some light on your backups, their sizes, schedules of full and...

Try running orphan user script in each and every user databases. This will drop and clear the anamolies in the user-login conflicts. As you are a sysadmin, you can still...