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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-11-10 : 08:27:45
|
| I am using sql server 2008.What is the sql script to truncate log on a database to gain more space please?Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-10 : 08:43:10
|
| Don't. Wrong approach.Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]Edit: and this http://www.sqlservercentral.com/articles/Transaction+Log/72488/--Gail ShawSQL Server MVP |
 |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-10 : 09:27:09
|
| Many people belive that log file is an optional piece of the database which keeps on filling and should be truncated. This is a wrong notion as rightly pointed out by GilaMonster. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-11-10 : 17:53:06
|
| Thanks |
|
|
|
|
|
|
truncate log file to gain space