How to check for LDF file size I.e. my database ldf size is 10 times the
size of mdf. is it ok. For having smaller ldf do i need to check for some sp
or tune sps and other DTS packages.
I am using JOB which execute 10 DTS once daily...
>> I.e. my database ldf size is 10 times the
size of mdf. is it ok
Could be - depends on the processing.
Have a look at this - it might help
http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html
> How to check for LDF file size I.e. my database ldf size is 10 times the
> size of mdf. is it ok. For having smaller ldf do i need to check for some sp
> or tune sps and other DTS packages.
> I am using JOB which execute 10 DTS once daily...