![]() The DBCC REBUILD_LOG command was unsupported and undocumented and we didn’t like advising customers to use it.Much of the advice of how to do this on the Internet missed steps out (particularly missing step 3!). ![]() I decided to add a new feature to SQL Server 2005 called EMERGENCY-mode repair that will do steps 2 and 3 as an atomic operation. And then all the other stuff like root-cause analysis and getting a better backup strategy.Take the database out of EMERGENCY mode.because a transaction altering multiple tables was lost) as far as your business logic is concerned ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |