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 ...
What do you do when you can't avoid huge transaction logs in SharePoint and your files are too large? Last month, I wrote about how to avoid having ginormous transaction logs within SharePoint ...
increments until it reaches a target free space limit. Run this script in the database with the file to be shrunk. 1. Set @DBFileName to the name of database file to shrink. 2. Set @TargetFreeMB to ...
I am running Windows SharePoint Services 3.0 on a Windows 2003 server. I just noticed that our hard drive was getting very low on space and that WSS_Content_log.LDF in 'C ...
I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large. Sure enough, it the templog.ldf file is a little over 9GB in size.<BR><BR>I honestly don't ...
The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback