Friday, March 30, 2012

log in MSSQL\Data\MSSQL\Data

hello,
we have a log in MSSQL\Data\MSSQL\Data\dm_Enterprise20050526161738_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 grow
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_Enterprise20050526161738_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 grow
> so fast in 2 days?
> thanks for any helpsql

No comments:

Post a Comment