ADNM Growing Database

[Jan Nabelek]

It is paid SQL server.

And are you familiar with SQL server administration? Are you able to set shrinking job? Otherwise I can find T-SQL command on my servers and post it here...

[e2e2]

We had the same problem in one of our customers with 4000 machines.

The problem is not ADNM, is MS SQL and thr transaction log file.

You can change the SQL Database properties to SIMPLE:

http://msdn.microsoft.com/en-us/library/ms189275.aspx

It is paid SQL server.

And are you familiar with SQL server administration? Are you able to set shrinking job? Otherwise I can find T-SQL command on my servers and post it here...

I just changed the database clean up to 1 day to try out and database is now 20 MB.

I will make it 1 week so after a week it will clean the database.

Thanks for your help.

[Jan Nabelek]

When the main problem with growing database is in logfile, try to set following job in SQL server Agent:
1.step: backup LOG Avast WITH NO_LOG
2.step: use [Avast]DBCC SHRINKFILE (N'Avast_log', 15)

When database is partially harmed, the best way is delete + create new DB in Maintenance tool, or recreate from older backup. Disadvantage - You will lose your special settings and dynamic conditions, (if you use any...)