Welcome to MSDN Blogs Sign in | Join | Help

Blogs from Suhas

Dirtying my hands in SQL Server

News

  • Locations of visitors to this page

      Add to Technorati Favorites

Browse by Tags

All Tags » DBCC   (RSS)
Revealing the secrets - Truncating a Transaction Log File
In my earlier blog post on Shrinking the Transaction Log files in SQL Server , I had mentioned that a VLF can be truncated only when all transactions, that have at least one command written into the specified VLF have either been committed or rolled back. Read More...
Database Corruption Part 2 :: How to attach a database using the Create-Replace method
Ok, so, as promised, here’s my next post on Database Corruption. In this post, we will have a look at how to attach a database that you have detached and can now no longer attach back to SQL Server. This may happen if the database was already corrupt Read More...
Page view tracker