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 |
|
baselbj
Starting Member
3 Posts |
 Posted - 2003-01-02 : 10:24:38
|
| i have sql server 2000 and need to clear the databse log file case it is so big how can i do this??? |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-01-02 : 11:17:45
|
| Are performing transaction log backup over time? If yes, then you can just issue a dbcc shrinkdatabase (or shrinkdb), or use the Enterprise manager to shrink the log file, using the shrink database option in the databases -> all tasks menu.There are some constraints: some times you need to move the active virtual log to be able to shrink a log file... It can be done by create a dummy table and perform some operaitons on it. You must check the log status and if the active log (status = 2) is in the beginning, then issue the dbcc shrinkdb, and a backup transaction with no log (if you have o tran log policy then it may not be necessary).Sérgio Monteiro |
 |
|
|
|
|
|
Log File is To Larg