I have a client that is running a SharePoint database on a server2008r2. Sql is 2012.
The Sharepoint_Config transaction log file ldf is huge (120gb). The mdf file is only 200mb.
I have been researching the shrink file command, or shrink file via the SQL Server management Studio.
I have ran a 'DBCC SQLPERF(logspace)' and the Log file space used is only 2.7 % on this database.
Can anyone advise me this is safe to do? and is there anything I need to do before running shrinkfile on the ldf file? except taking a full backup of the database.