[dba-SQLServer]SQL LOG File is Huge! 10GB - Help

Truncating logs, shrinking files...there's most likely an open transaction sitting out there that will prevent you from doing either!  Do DBCC OPENTRAN('your_database'), and if there is one or two see what they are doing (or not doing if sleeping) and go from there.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Michael Brösdorf
Sent: Wednesday, October 08, 2003 10:42 AM
To: dba-sqlserver at databaseadvisors.com
Subject: AW: [dba-SQLServer]SQL LOG File is Huge! 10GB - Help


Julie,

truncate the log before you shrink it, then it will actually be smaller.

Michael

-----Ursprüngliche Nachricht-----
Von: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]Im Auftrag von Julie Reardon-Taylor
Gesendet: Mittwoch, 8. Oktober 2003 15:35
An: AccessD at databaseadvisors.com; dba-SQLServer at databaseadvisors.com
Betreff: [dba-SQLServer]SQL LOG File is Huge! 10GB - Help



Hi Group,

All of a sudden, my BEDB.dbf file has grown huge.  The file itself and the log file are at 10GB.  I tried shrinking the database, and received a message saying that it was successful, however, the files are still the same size.  I'm receiving an event log error ID 17052 that states that there is no more room in the log file.  How can I resolve this problem?  It is causing problems on the server because the files are taking up so much space.  It is error 9002, severity 17.


Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net

_________________________________________________________________
High-speed Internet access as low as $29.95/month (depending on the local
service providers in your area). Click here.   https://broadband.msn.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com