MSSQL Transaction Log Shrink via MSSQL manager / mylittleadmin

To shrink the MSSQL transaction log via mylittleadmin / mssql manager, do the following queries:

select name,recovery_model_desc from sys.databases
GO 
Alter database DATABASE_NAME Set Recovery simple
GO
Declare @DATABASE_NAME_log sysname
select @DATABASE_NAME_log=Name from sys.database_files where Type=1
print @DATABASE_NAME_log

DBCC Shrinkfile(@DATABASE_NAME_log,100)

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is an SSL certificate?

An SSL certificate encrypts data that is sent between the server and you, your computer, your...

ASP.net impersonation

On some of our windows systems, the aps.net application may run as a separate user than your...

Wordpress on Windows IIS7

When installing wordpress on windows servers with IIS7, it is important to use the following...

Standard Mail Settings

Mail Server Info: Login: Is your full email address (example@example.com) Incoming mail...

How to upload / create your site.

Creating your site How you create your site depends on what you want to do with it.  You...