as a matter of fact u can change it

what if the initial log size is like 1 GB.

and for some reason log backup job failed

no-one noticed and the ldf file size went to 10 GB.

now even if...

in the end ,

if u rebuild indexes on primary,same thing will happen in secondary.

what u can do is depending upon the fragmentation levels decide which indexes to rebuilt and which...

thanks for your feedback steve.

this script is a modified version of another script which i wrote.that script was embedded in vbscript and it was supposed to be run on all...

thanks steve...

it is a pretty good practise. we dont have the authority to do all these things.but we can suggest this to the senior most DBA's.

Hi guys.

any comments would be appreciated.

I appreciate your solution.But you said that perhaps shorten the duration of log backup.will it help.will i get more trn files but of small sizes.

thanks for the reply....but what if there is a planned bulk insert.what can be done in that case

There are actually four parameters that you can change.The fourth one is filesize.This parameter value is in MB.First you have to set the filesize { set @filesize=100} then the...

Excellent Article.Learnt a lot in 5 minutes of reading this.

Hi,

So did you got it?? or still stuck ??

Regards,

Amar Sale

why no one is answering the question?

is it irrevelant/stupid/unworthy?

is it posted in wrong section?

is it about litespeed?

i m not forcing anyone....but i should know if i m making any mistake...

thanks gila.....i realised after some-time that its not right.but didnt exactly figure out why it cant be right.

yes there is one way to find out....

correct me if i m wrong...

if index is created on a filegroup and that filegroup is associated with a data file.

then creation date...

its a job that runs for 30 sec....i dont think that job is the problem.u can use counters or run a trace or

just run sp_who2 and check which...