I met a problem. I don't know how I can set the query up to automatically run. Right now it must be run manually inside of the SQL query analyzer.

Here is the query:
BACKUP LOG VCCS_PRODUCTION WITH NO_LOG
GO
USE VCCS_PRODUCTION
GO
DBCC SHRINKFILE (VCCS_Production_Log, 2, TRUNCATEONLY)
GO

I will be apreciated for your answer!

You can create a job, create a step and insert your statement inside
then schedule it.

Jaime E. Maccou
Applications Analyst

As jemacc said but you will need SQLAgent running to do this.

Alternatively you can use osql in a batch file and schedule running of this file using Windows Task Scheduler.

--

Joe

Thanks a lot for your help, Jamacc and Joe : )
I will try soon