At the moment SQL Server 2005 is running a database that is 8,9GB in size. the log file is 20.1GB in size and the HDD is filling up fast.
Now i know i can shrink the log file. but i can't find any answers as to what the Consequences are to doing that. this is a database witch feeds a production environment application so if any thing is broken, we have a problem.
We run a daily backup of the database.
So basicly what happens when i shink the log file, i don't lose any production data. but still i have the feeling that i am breaking some thing when i run the query:
DBCC SHRINKFILE('<Logfile_name>', 1) BACKUP LOG <Database_name> WITH TRUNCATE_ONLY DBCC SHRINKFILE('<Logfile_name>', 1) GO