You need to use begin and commit, when you are trying to run a batch. Either the entire upload is successful or nothing is updated.

I think SQL server also has...

Can you give some more information? I think you can run the DBCC checkDB statement with REPORT_ALLOW_DATA_LOSS option. It can retrive the log file, however, there may be some data...

One of our database writes huge logs as as we have created a Transactional Replication on that. I was trying to automate the process of truncating the logs as it...