Hi Mek,
Thanks for reply.
Interesting…I was thinking of something much smaller than that! 80mb for 20000 post and 400 users is a bit large I guess. Do you save files to the db too?
I guess I should give more $ :roll: to my host. I also should pay 40$ for each 50MB SQL2000 and 60$ for SQL2005! :cheesy:
And about transaction logs, does MySQL have transaction log too?
I tried to shrink the transaction via built-in SQL Query in YAF via the following command:
USE MYYAFDB;
ALTER DATABASE MYYAFDB
SET RECOVERY SIMPLE;
DBCC SHRINKFILE (MYYAFDB _Log, 5);
ALTER DATABASE MYYAFDB
SET RECOVERY FULL;
But came up with:
Statement not allowed within multi-statement transaction. Cannot perform a ShrinkFile operation inside a user transaction. Terminate the transaction and reissue the statement.
I took a brief look at MSDN and I didn't find any solution. The command is executed well in Query Analyzer of SQL Manager but not within Application. Any idea?
What about adding a DB optimization section to YAF (Defrag, Shrink, Backup and..)?
Regards