It's the type of backup you are doing. Check your backup propeties. Linda <<< [EMAIL PROTECTED] 5/ 7 2:37p >>> One of the database's in our SQL 7 DB keeps going into single user mode. I belive this happens after a transaction log backup. We are currently backing up our transaction log every 30 minutes. Does any body have any insight into why the DB would go into single User mode and if it is nessacary to backup the transaction log at this short of an interval? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
