Viewing 5 posts - 1 through 5 (of 5 total)
Thanks
Here is the result from the sys.database
masterSIMPLENOTHING
tempdbSIMPLEACTIVE_TRANSACTION
modelFULLLOG_BACKUP
msdbSIMPLENOTHING
mydbFULLLOG_BACKUP
August 15, 2011 at 2:54 pm
Thanks
Here is output from sys.database for "log_reuse_wait_desc" column
my _dbFULLACTIVE_BACKUP_OR_RESTORE
August 15, 2011 at 2:11 pm
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...
August 15, 2011 at 2:02 pm
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
August 15, 2011 at 1:58 pm
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...
August 15, 2011 at 5:41 am
Viewing 5 posts - 1 through 5 (of 5 total)