I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims "when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database. Changing the database from READ_ONLY to READ_WRITE causes SQLServer to re-create the transaction log file".
Well, I have marked a database as read only and changed it back to read write but the transaction file never disappears? Am I doing something wrong, am I not understanding what the book is trying to say or the book is wrong?
April 11, 2009 2:53 AM
May 14, 2009 6:43 PM