Microsoft SQL – geekmungus

Shrink Microsoft SQL Database Transaction Logs

November 5, 2022January 7, 2014 by Tristan Self

PROBLEM: Your SQL transaction log has grown to be really big, this might be because a load of data was added, or your backup procedures were failing to truncate the logs. SOLUTION: Take a backup of the database, then open the SSMS and then run this command: Now take a full backup of the database … Read more

Microsoft SQL 2000 SP4 In-Place Upgrade to SQL 2005 – Upgrade Advisor Error

November 5, 2022January 13, 2012 by Tristan Self

We had a very old server running SQL 2000 SP4 that we needed to upgrade to SQL 2005, as we didn’t have the staff resource available for a complete rebuild of the whole server to Windows 2008 and SQL 2008 we decided to do an inplace upgrade. All seemed to go swiminingly until I hit … Read more