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 |
|
aiman
Starting Member
18 Posts |
 Posted - 2007-08-12 : 08:20:15
|
| I have a Database name OBReporting,in the D:\Microsoft SQL Server\MSSQL\Data folder it maked a OBReporting_Log.LDF file its property is so High more then 31GB, and in that drive now has only 6GM free space.Please advice me how can i increase Free space in that Drive. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-12 : 12:08:30
|
| You need backup log to truncate committed transactions and free up space in log file if the db is not in simple recovery model. What you can do now are backup log then shrink log file. |
 |
|
|
aiman
Starting Member
18 Posts |
Posted - 2007-08-17 : 05:11:06
|
| After backing up If I delete this file then what will be the effect of that Data base. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-08-17 : 07:31:53
|
| ...you could screw up your database.search here for links re "shrink log file", starting with kristens FAQ in the "New to SQL server" forum.your problem is a result of potentially several other issues...ie wrong/no backup strategy, wrong/no recovery strategy, etc....you may have to sort these out first. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 00:54:57
|
| You can't delete it while the db is online anyway. |
|
|
|
|
|
|
High Property of .LDF file.