Microsoft SQL

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

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