How do I truncate a LOG?

I have SQL Server 2000 ...

I thought that Scheduled Backups would truncate the existing the Log
files... but, that doesn't seem to be happening.. I have one log file that i
s
quite large and growing... despite weekly backups....

What is the best way to truncate log files... ???

thanks..

If you have autoshrink option is on it will shrink, but shrink log only
if you have space issue.
By default SQL Server after backup truncate backed up log, but do not
free space.
It will reuse space when needed, and it helps to reduce load on server
for growing database files sizes.

You can use DBCC Shrinkfile to shrink database.
Look at books online for Shrinking the Transaction Log

Regards
Amish Shah

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/


"MSUTech" <MSUTech@discussions.microsoft.com> wrote in message
news:B46A8994-FA94-4261-B2BF- 2985256BC7F7@microso
ft.com...
>I have SQL Server 2000 ...
>
> I thought that Scheduled Backups would truncate the existing the Log
> files... but, that doesn't seem to be happening.. I have one log file that
 is
> quite large and growing... despite weekly backups....
>
> What is the best way to truncate log files... ???
>
> thanks..

MSUTech  wrote:
> I have SQL Server 2000 ...
>
> I thought that Scheduled Backups would truncate the existing the Log
> files... but, that doesn't seem to be happening.. I have one log file that
 is
> quite large and growing... despite weekly backups....
>
> What is the best way to truncate log files... ???
>
> thanks..

Remember that a database backup doesn't do anything to the logfile.
You'll have to specifically do a logfile backup in order to truncate the
logfile. Also keep in mind that a log backup doesn't shrink the actual
physical file - it only truncate it so the already allocated space can
be reused.

Regards
Steen

Thanks for the information...

One last question.... in regards to the SERVER PAGE FILE.... if this logfile
gets large... does it have any impact on the Server Page File....

in other words... does this logfile... sit in server memory???

thanks...

"Steen Persson (DK)" wrote:

> MSUTech wrote: 
>
> Remember that a database backup doesn't do anything to the logfile.
> You'll have to specifically do a logfile backup in order to truncate the
> logfile. Also keep in mind that a log backup doesn't shrink the actual
> physical file - it only truncate it so the already allocated space can
> be reused.
>
> Regards
> Steen
>