Sharepoint: shrink database on a fast way

  • Article

Hello,

we all know that large SQL databases in SharePoint will have large transaction logs on SQL in case the database is much in use. In case you are using only SharePoint backup and no SQL backup you may have a problem with very large transaction logs and you need to shrink the transaction logs manually.

How to shrink transaction logs in a fast way?

Solution 1. normally you need to do a database backup (a FULL backup) of each database then the transaction log is empty. But the transaction log file is still so large. That's not nice and because the file is empty but has a large size on the file system. 

My way to reduce the transaction log is a bit faster:

Execute this on each sharepoint database:

USE MyDatabase

GO

BACKUP LOG MyDatabase WITH TRUNCATE_ONLY

GO

DBCC SHRINKFILE (MyDatabase_log, 1)

GO

As result you will see a Transaciton Log file with a size of 1 MB.

Is that nice?

regards

Patrick