What is 'write-ahead log' in sql server 2000 ?



What is 'write-ahead log' in sql server 2000 ?..

Answer / Anubha Rastogi

The 'write-ahead log' (WAL) is a feature in SQL Server 2000 that allows transactions to be written to a temporary log before being applied to the database. This ensures data integrity and durability by allowing the database to recover from system failures, such as power outages or hardware malfunctions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How does index makes search faster?

1 Answers   QuestPond,


Explain go command in sql server?

1 Answers  


Explain transaction server explicit transaction?

1 Answers  


What is log shipping? Can we do logshipping with SQL Server 7.0 ?

1 Answers   IBM,


Explain few examples of stored procedure over triggers?

1 Answers   ADITI,


How will you go about resolving deadlocks?

1 Answers  


How can sql server instances be hidden? : sql server security

1 Answers  


What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,


which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  


What is a print index?

1 Answers  


DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,


Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  


Categories