<div>
Hi,<br />
<br />
Do you want to truncate a table that have log entries or to truncate the physical log file of a database? <br />
Also, do you want to make a backup of the log/table before truncating it?<br />
<br />
Regards,<br />
<br />
Marco André
</div>


Hi,

Do you want to truncate a table that have log entries or to truncate the physical log file of a database?
Also, do you want to make a backup of the log/table before truncating it?

Regards,

Marco André

<div>
<br />
<br />
What rrjegen17 suggested is a good practice. If disk space is a constraint for taking frequent log backups. And in case if you don not need point in time recovery. You can change recovery model to simple. But make sure you have full backups. I recommend this only if your database is not critical and if it is fine for you, if you can recovery last night backup. 
</div>




What rrjegen17 suggested is a good practice. If disk space is a constraint for taking frequent log backups. And in case if you don not need point in time recovery. You can change recovery model to simple. But make sure you have full backups. I recommend this only if your database is not critical and if it is fine for you, if you can recovery last night backup.

<div>
<div class="content wysiwyg-content">
Hello,<br />
I have an SQL 2005 Server and have a query which truncates my log files that I run manually whenever they get large in size. I would like to be able to save that query to a .sql file and have task scheduler run it every month or week on its own. How can I configure it so that I can use task scheduler to point to the .sql file and automatically run the query at a given date and time? I'm not sure how to get it to authenticate using a specific username and password etc. Please provide step by step instructions on doing this.<br />
<br />
Thank you!<br />
<br />
Sergio
</div>
</div>


Hello,
I have an SQL 2005 Server and have a query which truncates my log files that I run manually whenever they get large in size. I would like to be able to save that query to a .sql file and have task scheduler run it every month or week on its own. How can I configure it so that I can use task scheduler to point to the .sql file and automatically run the query at a given date and time? I'm not sure how to get it to authenticate using a specific username and password etc. Please provide step by step instructions on doing this.

Thank you!

Sergio

Automate SQL Query File

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.