Welcome! » Log In » Create A New Profile

Growing SQL Database.

Posted by Anonymous 
Growing SQL Database.
March 06, 2007 10:08PM
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).
Growing SQL Database.
December 26, 2007 08:04PM
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.
Sorry, you do not have permission to post/reply in this forum.