They are transaction log backup files. You will need to cosult whatever backup methodology you have to see if you can delete them. You *could* delete the ones from *before* the last full backup. This assumes you will never want to restore past your last full good backup.
David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Schreck, Tom We've done some research and found there's around 20GB of TRN files stored in a UTIL directory. I'm assuming the TRN files are transaction files. Can they be deleted? If so at what point can they be deleted? Thanks - Tom Schreck 817-252-4900 [EMAIL PROTECTED] I have not failed. I've found 10,000 ways that won't work. - Thomas Edison -----Original Message----- From: David L. Penton [mailto:[EMAIL PROTECTED]] Your database growth has exceeded the limits set for the database. Right click the DB in EM, properties, then check the sizes. You may need to increase the size (you can do it there). The PRIMARY filegroup is basically a logical device that all the database objects reside on. You can have multiple filegroups, and you can have objects that span multiple filegroups. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dave Livingston Are you out of space on the HD that your DB file sits on? How much space did you allocate to that DB? See if that may be your troubles. Dave David Livingston Network Admin 214-871-9117 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Schreck, Tom Does any one know what the 'PRIMARY' filegroup is? It's not a field in the CDATA table. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'CDATA' in database 'EAPubs' because the 'PRIMARY' filegroup is full Thanks - Tom Schreck 817-252-4900 [EMAIL PROTECTED] I have not failed. I've found 10,000 ways that won't work. - Thomas Edison ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
