Thanks

Here is the result from the sys.database

masterSIMPLENOTHING

tempdbSIMPLEACTIVE_TRANSACTION

modelFULLLOG_BACKUP

msdbSIMPLENOTHING

mydbFULLLOG_BACKUP

Thanks

Here is output from sys.database for "log_reuse_wait_desc" column

my _dbFULLACTIVE_BACKUP_OR_RESTORE

Thanks,

here is what I see after running the command

select name,filename,size/128"Actual Size",maxsize/128"Maxsize",fileproperty(name,'spaceused')/128"spaceUsed" from sysfiles

Database -- actual size =78981, max size =0 space used = 68741

DB_Log -- Actual size = 170806, max...

Thanks.

here is information from running the command

use master

exec sp_help_log_shipping_primary_database @database = 'yourdbname'

Last backup date = 2011-08-15 22:45:11.803

History_retension persiod = 5760

backup_retension_period =43200

Thanks

Can you expand on how to check usage with the log file.

So, the log file size could not be the issue with performance. I have enough space on the...