For your information, the log is using 3 different devices.
Appreciate the help.
Endang
-->Endang Rachmawati Adwiarto wrote:>>>> For SQL server experts out there,>>>> I'm using radiusNT 2.2 with SQL ODBC.>> I've ran it for about 3 months and my transaction log is building up.>> I tried to truncate it but the log space availability didn't increase its>> availability size.>> Anybody knows how do truncate the log size totally to zero?>>>> The situation of my log size compared to the data size is as follows:>> Log size: 1413 MB and -->Log Space Available178.69 MB>> Data size: 907 MB --> Data Space available:623.54 MB>>Run the following on your database and then truncate the log:>>DBCC CheckDB(Emerald)>>Where Emerald is you database name.>>-->Dale E. Reed Jr. (daler@iea.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>> ----------------------------------------------------------> RadiusNT Mailing List lists@iea-software.com>>