MS SQL Server - Truncate Log 7.0

Author

Truncate Log 7.0

CLM

2005-10-31, 11:23 am

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!

Hari Prasad

2005-10-31, 11:23 am

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!

Sponsored Links