Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...

If the *.evt files are corrupted, you may encounter the error messages mentioned here. There are various reasons why the Event Viewer log files can be corrupted ...

Microsoft on Thursday released Service Pack 3 (SP3) for SQL Server 2008. The new service pack arrives about one year after the release of Service Pack 2. SP3 contains a lot of fixes to the earlier ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we performed ...