Many times the large size of transaction log file (.ldf) in Microsoft SQL is too big which leads to performance issues and loss of valuable disk space.Therefore it's imperative to periodically do ...

My SQL Server ... or Files. If I am using the Management Studio interface, I generally select Files and shrink only the log file. This can also be done using TSQL. The following query will find ...

Learn how to shrink a data or log file in SQL Server by using SQL Server Management Studio or Transact-SQL. Shrinking data files recovers space by moving pages of data from the end of the file to ...

Log files can grow quite large. During an Accounting upgrade, the log file grew to 250Gb! And it did not shrink. The 'people' that wrote ... The physical file name "C:\Program Files\Microsoft SQL ...

I am running Windows SharePoint Services 3.0 on a Windows 2003 server ... is SQL. Run full backup of SQL databases. Keep the backups! Then in the SQL Management Studio shrink the log file sizes.