Comments
-
Here is the fix as it worked perfectly for me. http://piyushmittal.wordpress.com/2007/12/17/truncate-purge-sql-2005-database-log-files/ Steps:1) Detach the NCM database from SQL Server Management Studio. 2) Go to the location of transaction log and rename it (don’t delete the file yet!!) 3) Attach the database without the…
-
We have tried the following. 1. Change DB to full recovery mode 2. Did a backup of the db 3. Did a backup of the transaction log 4. Truncated transaction log. This completed without errors, but it doesn't appear that it worked. 5. Rebooted SQL box 6. Put DB back to SIMPLE. 7. Did a DB/LOG shrink. The database is still…
-
Did anyone find a fix for this? I have several reports doing the same thing. NPM 9.1 SP5. Orion\\Reports will never work, correct. But Solarwinds doesn't make it easy to make this very simple change.
-
I just checked that & recovery model is set to simple. ?? The cirrus db is 1.2gb & the .ldf is 14gb. Any way to delete, truncate or purge the .ldf & not kill the app or data? Sorry, I'm not a DBA or I'd have a better understanding of this stuff. I appreciate the help.
-
Thanks Yann. I tried your suggestion and it seems that my issue is the .ldf file is growing rapidly and not the DB. I'm running this option now & I'll let you know if this helps. Hopefully I'm on the right track. support.microsoft.com/default.aspx
-
Did you ever get a resolution to this problem? If so, what was the fix/culprit?