Truncate Log 7.0

Does anybody remember what the command is to "truncate the log" in Sql Serve
r
7.0.  I usually use dbcc shrinfile, but that doesn't work in 7.0.  It's been
several years since I had a 7.0 database and I just can't remember!

Hi,

2 Options:-

1. backup the transaction log using BACKUP LOG . This will clear the log
automatically

2. Truncate the log using Backup Log <DBname> with Truncate_only. This will
truncate the log.

After that if needed you can shrink the transaction log physical file using
DBCC SHRINKFILE.

Thanks
Hari
SQL Server MVP


"CLM" <CLM@discussions.microsoft.com> wrote in message
news:83B06319-C0F0-4F74-8D5E- 0A28B58DA10F@microso
ft.com...
> Does anybody remember what the command is to "truncate the log" in Sql
> Server
> 7.0.  I usually use dbcc shrinfile, but that doesn't work in 7.0.  It's
> been
> several years since I had a 7.0 database and I just can't remember!