First off I am not a SQL guy so I really need some assistance. We are running a SBS2003 server with SQL 2005 Premium. One of the databases is around 600MB and the transaction log is 125GB!! I attempted to backup the database but this did not clear the transaction log. I also tried backing up the transaction log but I did not have enough free space to back it up. I'm not sure if backing up the transaction would truncate it anyhow. Can anyone tell me how to get this back down to a normal size and how to prevent this from happening moving forward?
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…