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 |
|
arvindrang
Starting Member
1 Post |
 Posted - 2009-01-19 : 19:45:36
|
| Background:We use MS Navision as our ERP system. One of the things I noticed is that we have 4 log files and we should be getting rid of it since it takes too much space. Please find the attached document (3 pages) that details the log files and data files. It also has some info on VLF’s. since the active VLF (status = 2) is N:\MSSQL\Data\bcsnav_prod_2_Log.ldf file, I think I will have to delete the other 2 since I cannot delete the primary.Can you please suggest me the best way to delete the log files?I was thinking of doing the following:• BACKUP LOG bcsnav_prod WITH TRUNCATE_ONLY• DBCC SHRINKFILE(bcsnav_prod_1_Log,2)will it affect Microsoft navision performance?Any help will be highly appreciated. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-20 : 08:26:47
|
| You should be backing log regularly to avoid this. |
 |
|
|
|
|
|
Transaction log - extra log file delete