TwitterLinkedInBlog

Friday, August 16, 2013

SharePoint 2010 Dev: Reduce DB File Size

IN DEV, NOT PROD:

Reduce Database Log File Size:
USE [DatabaseName]
ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(LogFileName, 1)
ALTER DATABASE [DatabaseName] SET RECOVERY FULL WITH NO_WAIT

Reset User Profile synchronization:
http://technet.microsoft.com/en-us/library/ff681014(v=office.14).aspx


Resources:
http://troyvssharepoint.blogspot.co.uk/2012/10/sharepoint-user-profile-sync-database.html
http://technet.microsoft.com/en-us/library/cc262731(v=office.14).aspx

No comments: