Microsoft SQL – geekmungus.co.uk

Shrink Microsoft SQL Database Transaction Logs

January 7, 2014November 5, 2022Tristan SelfLeave a Comment

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 […]

More...

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

January 13, 2012November 5, 2022Tristan SelfLeave a Comment

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 […]

More...

Category: Microsoft SQL

Shrink Microsoft SQL Database Transaction Logs

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

Multicast – IGMP Snooping and IGMP Querier – Sender and Reciever(s) in same VLAN/Layer 2 Segment

Install VMware PowerCLI

VMware PowerCLI Discover VMs Restarted by VMware HA (Host Failure)