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

Michael Brösdorf michael.broesdorf at web.de
Wed Oct 8 10:42:06 CDT 2003


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



More information about the dba-SQLServer mailing list