Browse by Tags

• SQL Server

• Data purity

  Reviewing DBCC CHECKDB syntax for SQL Server 2005, I found a [DATA_PURITY] option added to its syntax. This option enable the following checks on each column value of those datatypes: Unicode character - The data length should be a multiple of 2. Datetime... Posted Nov 26 2007, 10:39 PM by leo.pasta with | with no comments Filed under: SQL Server, Recovery

• Losing your Transaction log

  Technorati Tags: SQL Server , Recovery Some days ago, my boss got on my desk asking if I could take a look at one database that was not opening. That DB was in a virtual machine used for our sales presentations. For some reason, several files got corrupted... Posted Nov 20 2007, 12:17 AM by leo.pasta with | with no comments Filed under: SQL Server, Recovery