Backing up log file with a script setup as a job

Is there any way to include in this script below something
to tell the job to backup will the log file when it gets
to a certain percentage say 85%.
Thanks,
Aboki.
/* Script for backing up the transaction log when it is
getting full and clear the space for the log file. */
/* This can also apply to any other system but you need to
change drive and part location */
/* to match where backup location */
Backup LOG IntegraProd TO
DISK = 'D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\IntegraProdTran.bak'
GOYou could write a job to run every so often, which uses DBCC PERFLOG
to get information about log space and log space used. If log space for your
database is > 85% then issue your t-sql command.
The log is cyclic, it should wrap around and re-use empty space
where possible. It needs to keep information on the oldest active
transaction
for rollback. If your log is constantly at a certain size, this will most
likely be
right for the database anyway.
HTH
"Aboki" <waco361@.hotmail.com> wrote in message
news:08d801c3627b$37d262a0$a001280a@.phx.gbl...
> Is there any way to include in this script below something
> to tell the job to backup will the log file when it gets
> to a certain percentage say 85%.
> Thanks,
> Aboki.
>
> /* Script for backing up the transaction log when it is
> getting full and clear the space for the log file. */
> /* This can also apply to any other system but you need to
> change drive and part location */
> /* to match where backup location */
>
> Backup LOG IntegraProd TO
> DISK = 'D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\IntegraProdTran.bak'
> GO|||You can set an alert to start the job. There should be an example alert you
can modify already installed with SQL.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aboki" <waco361@.hotmail.com> wrote in message
news:08d801c3627b$37d262a0$a001280a@.phx.gbl...
> Is there any way to include in this script below something
> to tell the job to backup will the log file when it gets
> to a certain percentage say 85%.
> Thanks,
> Aboki.
>
> /* Script for backing up the transaction log when it is
> getting full and clear the space for the log file. */
> /* This can also apply to any other system but you need to
> change drive and part location */
> /* to match where backup location */
>
> Backup LOG IntegraProd TO
> DISK = 'D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\IntegraProdTran.bak'
> GOsql

Average Percentage in Matrix Subtotal

I have a matrix like the following:

Period 1 2 3 4 etc. Should be:
name1 3% 1% 2% 3% 2.25%
name2 4% 2% 1% 5% 3%
etc.
Should be: 3.5% 1.5% 1.5% 4%

I want to get the average percentage along the bottom row and the last column.
Using subtotals it just adds all the percentages. Is there any way to do
this? I've seen a lot about InScope but I'm not sure if it would help or how
to use it

These threads might help answer your questions:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=22493&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=648316&SiteID=1

Average Percentage in Matrix Subtotal

I have a matrix like the following:

Period 1 2 3 4 etc. Should be:
name1 3% 1% 2% 3% 2.25%
name2 4% 2% 1% 5% 3%
etc.
Should be: 3.5% 1.5% 1.5% 4%

I want to get the average percentage along the bottom row and the last column.
Using subtotals it just adds all the percentages. Is there any way to do
this? I've seen a lot about InScope but I'm not sure if it would help or how
to use it

These threads might help answer your questions:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=22493&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=648316&SiteID=1