I know this is an old post but just FYI that "bulk logged" mode will help with growth in your actual tran log, but won't do much for tran log backups...

For others interested in this topic:

I had an experience today on SQL 2014 where a synonym in Database is pointing to a table in Database [A] on...

Just a note that in Server 2012 R2 at least, the normal Windows "Share..." dialog does not allow you to search for or add Computers to the share. You have...

Hi webrunner - did you get this working?

I'm trying to do this exact same thing with the same starting script, running on SQL Agent on a SQL 2012 box.

I've...

rew-370421 (10/29/2009)

---

Hi Steve, I looked through my SQL2K5 software and found no setup executables with x64. I did find a few filenames with x64 on them like: sqlncli_x64.msi and SqlWriter_x64.msi...

Great to hear! Thanks for taking input.

Please see this similar question:

http://ask.sqlservercentral.com/questions/94213/converting-multiple-rows-into-single-row.html