Here is the script for job that you need to run for decrease the LDF file /***** Script start*** USE [DB_NAME]; ALTER DATABASE [DB_NAME] SET RECOVERY SIMPLE; CHECKPOINT; DBCC SHRINKFILE ([LOG_FileName], 1); ALTER DATABASE [DB_NAME] SET RECOVERY FULL; /***** Script End*** The above script reduce the log file up to 1,024 KB Note: before doing any activity kindly make the back of each database. Regards 3art Technology Experts http://www.3art.tech

This is a process how you make the Link column in your sharepoint link original url Create a calculated column which concatenate the url text with an existing column value. This seems to be an easy task, except one thing: SharePoint doest not render hyperlink in calculated column by default. For example, I have a list with 2 columns: Search term and Google Search. Google Search is a calculated column with this formula Now, this is what I will get by default: There are a few ways to fix this problem. Usually people will recommend you to create a Hyperlink column instead and create a workflow to update the Hyperlink value ( http://social.technet.microsoft.com/Forums/ar/sharepoint2010customization/thread/32d32e47-3256-4806-8775-c250b6243038 ) . Or, you can place a script on the page that loop through the HTML nodes and replace the unfriendly html tags with a hyperlink as described here http://practicalsharepoint.blogspot.com/2011/10/dynamic-hyperlinks-in-calculated.html ...