As you have been using the Server and Hosting service administration for Windows already know, in the process of using Log belong to Database is born and takes up a lot of Disk resources on Hosting. This if you do not pay attention and monitor the test, the file Log This can generate up to tens of GB, even hundreds of GB.
So for a large database system and read and write data continuously, you need to pay attention to this problem and handle and delete the log on a regular basis to free up Disk space. But many of you always think that the problem can only be handled with system Admin rights, but below, you can handle it without admin rights. Please do it.
- Log into “SQL Management Studio” with database user and password information.
- Open window "Query" and run the command below.
USE your_db_name_here
GO
ALTER DATABASE your_db_name_here SET RECOVERY SIMPLE
DBCC SHRINKFILE(2,0)
ALTER DATABASE your_db_name_here SET RECOVERY FULL
GO
After running the command, you have solved the problem.
Goodluck!
Hao Pham – Technical Department!
Post a Comment
Post a Comment