How can I shrink a large transaction log in StarTeam?
How can I shrink a large SQL Server transaction log in StarTeam?
Transaction log can rapidly grow and in some instances they can reach as large as 100GB. Obviously this results in adverse effect on system resources on the server. To resolve this problem you should do the following, backup the database with ?backup log DATABASENAME with truncate_only? and shrink the transaction log with (dbcc shrinkfile(DATABASE_log,0).
For full details on this command please refer to Microsoft site for detailed information on the SQL statement. Please also ensure that your DBA performs any such actions.
Author: Eyob Kidanmariam