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 |
How does index makes search faster?
Explain go command in sql server?
Explain transaction server explicit transaction?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Explain few examples of stored procedure over triggers?
How will you go about resolving deadlocks?
How can sql server instances be hidden? : sql server security
What is referential integrity and how is it achieved?
which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help
What is a print index?
DIFFERENCE BETWEEN SQL SERVER 2005 and 2008
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?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)