Thanks again for the help.

My script is below.

backup log mydatabase

to disk = '\\someserver\backups\logbackup_timestamp.bak'

with no_truncate, init

Thanks for the help.

I attached the results. There are 935 rows.

My log_reuse_wait_desc is 'LOG_BACKUP' (recovery_model_desc = FULL). Is this correct? I appreciate all the assistance.

Thanks for the reply. The log file is not being reused after backup and there are no active transactions (DBCC OPENTRAN) causing the size. I did not have this issue...

Ther eis a trigger that does an additiional delete and insert. That would explain this. I see the same results for updates where it shows (1 row(s) affected) then the...

That was it. Stupid mistake on my part. Thank you for the help.:satisfied:

I use the ASCII function to return the ascii characters of the string and it returns char(32) numerous times on the end of the string. When I run a REPLACE...