Friday, March 30, 2012

log in MSSQL\Data\MSSQL\Data

hello,
we have a log in MSSQL\Data\MSSQL\Data\dm_Enterprise20050
526161738_log1
that is over 50 Gig. Can someone tell me wht this log is? also we re-boot
on the weekends, so if this log gets cleared after a reboot how could it gro
w
so fast in 2 days?
thanks for any helpDo you have a backup plan that includes a Full Backup and a Transaction log
backup? That would help to keep the size of log under control.
I am not sure whether you want to know what database the log belongs too or
why is so big. Can you elaborate more, please?
Thanks
"gd" wrote:

> hello,
> we have a log in MSSQL\Data\MSSQL\Data\dm_Enterprise20050
526161738_log1
> that is over 50 Gig. Can someone tell me wht this log is? also we re-boo
t
> on the weekends, so if this log gets cleared after a reboot how could it g
row
> so fast in 2 days?
> thanks for any help

No comments:

Post a Comment