input license here

Instructions for Shrink Log Database SQL Server without Admin privileges


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!


Related Posts
Diệp Quân
Nguyen Manh Cuong is the author and founder of the vmwareplayerfree blog. With over 14 years of experience in Online Marketing, he now runs a number of successful websites, and occasionally shares his experience & knowledge on this blog.
SHARE

Related Posts

Subscribe to get free updates

Post a Comment

Sticky