<div>
First off, backup the log to remove the inactive part. <br />
<br />
Then<br />
<br />
DBCC SHRINKFILE<br />
<br />
To reduce the filesize<br />

</div>


First off, backup the log to remove the inactive part.

Then

DBCC SHRINKFILE

To reduce the filesize


<div>
Oops. looking back I wasn't clear. This command can be run in &quot;Query Analyzer&quot;. Copy, paste, edit dbnames and click &quot;Run&quot; or hit F5.<br />
--------<br />
Backup Log DBNAMEHERE with truncate_only<br />
<br />
DBCC SHRINKFILE ('DBLOGICALNAMEHERE_log', 2)<br />
---------
</div>


Oops. looking back I wasn't clear. This command can be run in "Query Analyzer". Copy, paste, edit dbnames and click "Run" or hit F5.
--------
Backup Log DBNAMEHERE with truncate_only

DBCC SHRINKFILE ('DBLOGICALNAMEHERE_log', 2)
---------

<div>
<div class="content wysiwyg-content">
easy way to shrink a sql log file in windows 2003 server OS
</div>
</div>


easy way to shrink a sql log file in windows 2003 server OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

Network Operations includes asset management, help-desk supervision, security and user policies, infrastructure administration and anything else that affects the operation of your network. Discussions will include those of best practices in platforms, configurations, performance, security and accounting.