
Can Transaction Log Backup be Initiated If Some % Full
Vivek,
Am aware that you cant adopt that storproc as it is...thats why I mentioned
for the modification.
Quote:
> But can I specify which File it should see for growth.
> I mean I am concerned with transaction log growth in a
> Particular Database.
select * from databasename.dbo.sysfiles where name='logfilename' and from
there you can
improvise on that storproc.
Quote:
> Can't I specify a Percentage above which it should fire
> the backup Job.
May be you can pass a destination level to the stor proc and once the
current size crosses that, raise the error.
With further calculations inside, you can even calculate the percentage.
Dinesh.
Quote:
> Thanks Dinesh ,
> But can I specify which File it should see for growth.
> I mean I am concerned with transaction log growth in a
> Particular Database.
> Can't I specify a Percentage above which it should fire
> the backup Job.
> Vivek
> >-----Original Message-----
> >Vivek,
> >Make necessary modifications to:
> >http://www.dbmaint.com/download/utilproc/sp_dbm_checkfileg
> rowth.sql
> >Once it crosses the limit do a
> >exec msdb..sp_start_job.
> >Dinesh.
> >> I was curious whether Transaction Log Backup be
> initiated
> >> as soon as it becomes Some % full .
> >> I know it can be done if we have a Job checking every
> some
> >> minutes and then initiating a Job to backup.
> >> But can we have an alert for soem % full of Transaction
> >> Log at any point of time and then Initiate a Job for
> >> Transaction Log Backup as a Result of the Alert.
> >> -Vivek
> >.