I am not sure whether I understood your problem correctly. Check out
these!!

(1) Identify and optimize your monitoring process. Reduce logging
wherever possible

(2) Set the recovery model to SIMPLE. This mode doesn't log the
transactions and you wouldn't able to perform point-of-time restores,
but you would be able to take full database backups

(3) Archive old data and move it to different server.

John

-----Original Message-----
From: Sara Lee [mailto:[Email Address Removed]
Sent: Monday, June 16, 2003 1:05 PM
To: LazyDBA.com Discussion
Subject: How to stop a database from growing - Please help

Hi, We have a database which is used to monitor and
is set to Unrestricted growth for both transaction log
and database. We do need this data but at the same
time, there are not much empty space left on the
server. How do we manage that? Please respond.
Thanks.

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page