In SQL Server 2000 we have an intranet database (which uses sharepoint) and the .ldf file is now over 50GB and the .mdf file is over 7GB.
The backup runs every night.
It's Recovery Model 'Full'
Is there anything I can do to make the files smaller?
I've seen advice to truncate the database with this command
"backup log dbname with truncate_only"