Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sauk11
Starting Member
2 Posts |
 Posted - 2007-12-03 : 12:03:42
|
| I am using SQL 2005. I have one very big database. The size of the DB is 1500986.88 MB and space available is 149359.48 MB. There are log files in this DB. The size of my log files are growing so big. The currently allocated space of one log file is 799874.50 MB and available free space is 38281.67 MB (4%). And the currently allocated space of another log file is 1500 MB and available free space for this log file is -760092.83 MB (-50672%) I am not sure how come available free space for the 2nd log file becomes –ve. What does it mean? If I shrink log file, will I get any extra space? If not, what is the solution? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-12-03 : 12:44:44
|
| What is your recovery model?Are you running log backups (if it's not simple model?)Is there an open transaction stopping the log from clearing?Seehttp://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sauk11
Starting Member
2 Posts |
Posted - 2007-12-03 : 14:06:09
|
| My recovery model is Full. I am not running any log backups. I am not sure what do u mean by "Is there an open transaction stopping the log from clearing?" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-03 : 14:13:15
|
| Change your recovery model to SIMPLE if you don't require point in time recovery. Then shrink the file down with DBCC SHRINKFILE.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-03 : 22:27:19
|
| If you need keep full recovery model, you have to backup log in schedule. |
|
|
|
|
|
|
size of log life