log flush counters

What is log flush ? I see a lot of these counters under the
SQLServer:Databases Object in perfmon...A log flush occurs when a transaction log buffer is written to disk. Data
are written to the database transaction log before the modified data pages
so that SQL Server can guarantee committed data are permanently persisted
and uncommitted data rolled back, if needed.
You can read more about the transaction log architecture in the SQL 2000
Books Online <architec.chm::/8_ar_da2_876t.htm>.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OvXyaYpaEHA.1048@.tk2msftngp13.phx.gbl...
> What is log flush ? I see a lot of these counters under the
> SQLServer:Databases Object in perfmon...
>sql

log flush counters

What is log flush ? I see a lot of these counters under the
SQLServer:Databases Object in perfmon...A log flush occurs when a transaction log buffer is written to disk. Data
are written to the database transaction log before the modified data pages
so that SQL Server can guarantee committed data are permanently persisted
and uncommitted data rolled back, if needed.
You can read more about the transaction log architecture in the SQL 2000
Books Online <architec.chm::/8_ar_da2_876t.htm>.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OvXyaYpaEHA.1048@.tk2msftngp13.phx.gbl...
> What is log flush ? I see a lot of these counters under the
> SQLServer:Databases Object in perfmon...
>

log flush counters

What is log flush ? I see a lot of these counters under the
SQLServer:Databases Object in perfmon...
A log flush occurs when a transaction log buffer is written to disk. Data
are written to the database transaction log before the modified data pages
so that SQL Server can guarantee committed data are permanently persisted
and uncommitted data rolled back, if needed.
You can read more about the transaction log architecture in the SQL 2000
Books Online <architec.chm::/8_ar_da2_876t.htm>.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OvXyaYpaEHA.1048@.tk2msftngp13.phx.gbl...
> What is log flush ? I see a lot of these counters under the
> SQLServer:Databases Object in perfmon...
>

Log File Flush Training for Newby

Sorry to ask such a basic question but I have inherited this DBA position and I have no SQL training...

I have a log file that is 148GB (yes GB) but available space is 18GB. I am backing up to \\server\share temporarily but want to free up the space. How do I flush it? I ran maintenance to shrink but not nuch success. It was not setup right initially, as the max size is 2,048,512 (MB). I'm guessing the initial dba was thinking it was KB. Anyway, I need to flush (or whatever it is called now) to reduce the size.

We had BackupExec but they got rid of that for Symantec Backup Exec System Restore which backs up the whole server as an image so it does not backup and flush the logs.

Any suggestions?

Thanks in advance.Hi,

see this kb for more information: http://support.microsoft.com/default.aspx/kb/873235

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de