Which SQL Server database does not follow ACID properties? Explain the reasons behind your answer.
The tempdb database does not follow the ACID property of "Durability".
Whenever Microsoft SQL Server is restarted, the tempdb is recreated. Any data that was committed to the tempdb is lost and replaced by a fresh copy from the model database, therefore violating the durability property which states that the effect of a transactoin must be persisted within the database irrespective of the state of the system.
Read through the page referenced (under the "Read More..." section) for more details.
Read More.. [240 clicks]
Published under: SQL Server Interview Questions · DBA Interview Questions · · ·