Growing SQL Database.

I am working with someone who has Arcserve running with a MS SQL back end. The
database keeps growing every night, even though the data on the disk is not
increasing noticeably, and the autocompress feature is turned on for the database.
Can anyone here offer information on how to shrink the MS SQL database?

_______________________________________________
If you'd like to join the discussion, go to http://www.backupcentral.com and get
a user id. Then subscribe to one or more of our mailing lists or follow the
discussions in one of our forums (http://www.backupcentral.com/phpBB2).

Is the database growing, or the transaction log?

If its the transaction log, do a full sql aware backup, or change database type to simple

My database grew to 12GB, i had to create a new one .. i could not get it to shrink. I had disabled pruing, i wanted to keep a list of backup jobs for ever.