Table of Contents
Microsoft is a widely used database in windows server, also its be default SQL server with a Plesk control panel which is used on windows base server in hosting industries. Every database has its own property and limitations set when it gets created, many times it happens that these resources get exhausted after a certain period of time. And one of the commonly reported issues about this is “The transaction log for database ‘xxx’ is full”. When you reach your limitation of transaction log size you get this issue
What is a transaction log file, it’s simply the record of the activities performed on the database and a complete track recode of it, It also uses in database recovery so you know what’s the importance of it, a Transaction log file (.IDF) keeps on increasing by the period of time as the transactions keep growing and in most case, if the database has any unidentified transaction its cause the log fie filled rapidly.
There is two way of solving this issue.
Many of us know about the shrinking option now let’s see how we can shrink the transaction log file.
We can easily perform this action by using the SQL server management studio for shrinking the transaction file.
Step 1 : Login into the SQL server management studio with “SA” user
Step 2: Expand the databases > and select the database name which is having transaction log size full issue
Step 3: Right Click on database name and go to Task > Shrink > Files
Step 4: Here, in this step, you have to select “File Type” as “Log” and “File Name” of the transaction log file. And then, you will be seeing a check box in name of release unused space. Click on the check box and this enables us to reduce the transaction log files space but it doesn’t delete any files to reduce the space.
Step 5: You can find another check box option called “reorganize files before unused space”. When you select this option it will allow you to enter the value for shrinking the logs. If you use this option then this is permanent so by default, your process will be cleared. by doing this you mean to reduce the rows and to relocate on unallocated pages.
Step 6: Here, you can choose the percentage left out for database shrinkage. The percentage count can be changed between 0 and 99. But this step is enabled only when you select 2nd option which is “reorganize files before releasing unused space”.
Step 7: The third option you can go with is an empty file by migrating the data to other files in the same file group. From the same group, it moves the files to a different location after then, the open space file can be deleted.
Step 1 : Login into the SQL server management studio with “SA” user
Step 2: Expand the databases > and select the database name which is transaction log size issue
Step 3: Right click on the database and click on “Properties”
Step 4: Go to the “Files” section from the left-hand menu list as shown below and update the LOG size on the right-Hand Side under the Size(MB) section as shown below.
Both ways are suitable to tackle this issue and can be used to fix it. Alternatives for responding to a full transaction log include:
Backing up the log.
Visit:- Hostripples!
As the demand for virtual private servers (VPS) continues to grow, businesses and individuals are faced with a crucial decision:…
Web hosting is a large industry, as many other factors help any web hosting provider to form a company. The…
Welcome to the complete guide to WordPress security best practices in 2024. As technology evolves rapidly, implementing strong security measures…
Hey, wanted to learn about web hosting? Or do you want to start a new website and need hosting? Questions…
In today's digital world, the threat of DDoS attacks has become increasingly prevalent. These types of attacks have the power…