EV Database Log File - Large but empty
I have a few EV tranaction log files that are really large, and they are empty. For example, the EVDA log file is 70GB. The "currently allocated space" is 68GB, and the "available free space" is 68GB. The "initial" database size is also 68GB.
When I try to shrink the transaction log file to say 500MB, the process fails since the "currently allocated space" is 68GB.
Is there a way to reduce the size of the tranaction log file? Can I reduce the "initial" database size?
Thanks
Ron
you might want to run this by your DBA like jw said. if you're feeling up to it you can do the following:
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GOeither way, be sure to run a full backup for good measure before making any changes.