Full Backups & Transaction Logs Backup

  A general misconception when it comes to transaction log management, is that the transaction log gets automatically TRUNCATED (underlined, as I am not saying SHRINKED!!!) when a full database backup is performed.   This is completely untrue, and if you just don’t believe it, just open Management Studio, right click your DB, select task …

4

BackupRestore & Corruption – What is worth to know

Just being discussing recently the Backup\Restore best practices (related to corruption) and wanted to share some information.   SQL Server Backup\Restore in SQL (when actually done directly from SQL, not from a 3rd party application – I come to that in a second) offers many options which are:   – Checking the backup consistency while performing…

1

SQL Server 2005 SP2 – Recommended Build – Update

I’ve posted a blog entry some time ago about Microsoft recommendation for SQL Server SP2 builds: SQL Server 2005 SP2 – Recommended Build?   Last week Microsoft has released a new SecurityBullettin (MS08-040 – Vulnerabilities in Microsoft SQL Server Could Allow Elevation of Privilege) which while we’re waiting for the release of SP3, changes Microsoft…


Madagascar – We need your Help!

  I don’t often blog about our team initiatives, but here’s one which is very important and we need the most help with. It’s like that famous slogan… “every little helps” 😉   Local Software Engineer to race through tropical rainforest on a bicycle   15 PFEs of Microsoft are pedalling a massive 420km across…

1

Assess your System (Part 2of3) – SQL BPA

  As a second tool to assess your system configuration, today I am going to post about SQL Server BPA (another acronym!) aka SQL Server Best Practices Analyser (better).   We have 2 versions available:   – one for SQL Server 2000 (http://www.microsoft.com/downloads/details.aspx?familyid=b352eb1f-d3ca-44ee-893e-9e07339c1f22&displaylang=en) – one for SQL Server 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en)   And no, I hadn’t…