Hi All,
I have received "Disk Space Near Max" message from the network solutions,
so how can i truncate the database log file.
I user the simple recovery model and growth size=1024mb.
Please provide me the detail steps.


Thanks,
kumar.

To truncate your MS SQL log file you can run the query:



within your SQL management program (replacing db_name with your database name). Alternatively you can use the same query within an ASP file by inserting the line:



after initiating a database connection.

I executed the query in sqlserver 2005, but i didn't endup with the solution. I didn't find any change in log file. Is there anyother way to truncate the log file??


Thanks,
Kumar

That is the only way I know of to truncate the log file for MS SQL. I did take a look at your database and currently your data file (not the log) is using 55MB, and the log is only using 1MB.

You have set your database quota to 50mb in your networksolutions.com account manager for the MS SQL db in question, and this is the reason why you cannot currently write to the database. To fix this issue you can either remove data from your database or raise the quota allocated to it from your database manager in your Network Solutions account.