The ramblings of a computer geek
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...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...I recently had to resolve some TNS listener errors on a Oracle database server. It was Oracle 11g running on Microsoft Windows 2003 Server R2 SP2 32bit. Basically the problem was that the memory Oracle was using was hitting the 2gb ram limit in the 32bit user space. Adding the /3GB switch to the end […]
More...I recently completed a migration of an 8 year old Oracle server to a nice new VM running on VMware Vpshere 4.1, this went without too many problems. However when people started to use it, the performance suffered and the server ground to a halt. The software vendor whose database it was imediately said, “ah […]
More...