what is meant by logfile in sqlserver 2005?

Hi,

Pls try to follow: http://decipherinfosys.wordpress.com/2008/04/02/log-file-viewer-in-sql-server-2005/

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Hi

Every Database have Data file (*.mdf) and Log File (*.ldf)

1. Whenever the write(Insert/Update) operation perform on a Table, First the data will be written into the Log file(called Gost Data) after then the Data will be pushed into Data file (*.Mdf).

2. Whenever the read(Select) operation perform from the Table, First the data will be loaded into the Cache(Read-ahead read) after then the Data will be pulled to the client.

The Pushing/Pulling the data from Log/into Log will be performed by the Relational Engine of SQL Server.

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Hi,
for information Check this link

http://blogs.techrepublic.com.com/datacenter/?p=448

LP MER

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Good Explanation PandianS


Thanks

Thank you for posting at Dotnetfunda
[Administrator]

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator