Truncate the transaction log in query analyzer. Then set up a process to backup the database each night with a step in that job that truncates the log before the backup process. DBCC SHINKFILE (arsystem_log,100mb,TRUNCATEONLY) press F5 key. arsystem_log is the name of your arsystem log file, 100mb is what you want the size to be, TRUNCATEONLY is the action. Rob
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
