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

http Error codes

The following are http status and error codes that are returned for each file access via a web...

Frontpage Publishing via FTP

Frontpage extensions are not supported on our servers due to bugs in the extensions (some...

How to upload / create your site.

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

What is an SSL certificate?

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

Standard Mail Settings

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