SQL Server Performance Forum – Threads Archive
Log file size
I noticed that one of my databases has the following file sizes: Data: 1,487,360 KBLog: 109,875,200 KB My transaction log file is more than 100GB!! What should I do? Why this had happened? Thanks, Farhad R
[email protected]
You are not doing transaction log backups. You need to set your recovery model to simple. Right-click on the database, go to properties, find the recovery model. It will probably say Full. Change it to Simple. Do the same thing for the model database. When you are done with this, run DBCC SHRINKDB(‘dbname’)
MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Transaction log backups enable you to recover the database to a specific point in time, and if you feel so then schedule regular backups of Transaction log in order to take care of size of Tlog. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thank you for great help. My problem is solved now. I could shrink the DB using the EM but I got the following error message when I ran DBCC ShrinkDB(MyDBTemp) Server: Msg 7959, Level 16, State 1, Line 1
The DBCC statement is not supported in this release.
DBCC execution completed. If DBCC printed error messages, contact your system administrator. My SQL Server version is 8.00.760. What release it is talking about? Farhad R
[email protected]
Its SP3/sp3a now andhttp://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37 link to track versions of SQL Server. What was the edition installed? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>