What Is 'write-ahead Log' In Sql Server 2000 ?

1.	What Is 'write-ahead Log' In Sql Server 2000 ?
Answer» Once data is stores in MEMORY USER can make changes to that a log FILE is generated. This log file is generated in every five minutes of transaction is DONE. After this sql server writes changes to database with the HELP of transaction log files. This is called Write-ahead log. Once data is stores in memory user can make changes to that a log file is generated. This log file is generated in every five minutes of transaction is done. After this sql server writes changes to database with the help of transaction log files. This is called Write-ahead log.

Answer»

Once data is stores in MEMORY USER can make changes to that a log FILE is generated. This log file is generated in every five minutes of transaction is DONE. After this sql server writes changes to database with the HELP of transaction log files. This is called Write-ahead log.

Once data is stores in memory user can make changes to that a log file is generated. This log file is generated in every five minutes of transaction is done. After this sql server writes changes to database with the help of transaction log files. This is called Write-ahead log.

Discussion

No Comment Found

Related InterviewSolutions

When I Run The Sql Server 2000 Setup, It Just Hangs. What Do I Do?
How Do I Perform An Unattended Install Of Sql Server 2000?
How Do I Install Only The Client Tools Of Sql Server 2000?
How Do I Determine How Many Instances Of Sql Server Are Installed On A Computer?
How Do I Find Information About The Install Locations For The Various Instances Running On A Computer?
What Are The Different Editions Available In Sql Server 2000?
Are There Any Preferred Steps That Need To Be Taken Care Of Before Starting The Installation Of Sql Server 2000?
What Is Awe?
What Is Dirty Page?
What Is Check-point?