log file full

The log file for database 'dbname' is full. Back up the transaction log for
the database to free up some log space.
How can i free up the space?Win
BACKUP LOG and then DBCC SHRINKFILE command.For more details please refer to
the BOL.
"Win" <aaa@.aaa.com> wrote in message
news:eu4XxnOaGHA.4916@.TK2MSFTNGP04.phx.gbl...
> The log file for database 'dbname' is full. Back up the transaction log
> for
> the database to free up some log space.
> How can i free up the space?
>|||Win (aaa@.aaa.com) writes:
> The log file for database 'dbname' is full. Back up the transaction log
> for the database to free up some log space.
> How can i free up the space?
You can delete other files so that the log can grow, or you can backup
the transaction log with BACKUP LOG.
But you should also ask yourself how you ended up in this situation. Did
you perform some wild update operation? Or did it come out of the blue?
What I'm getting is that when you run with full recovery, you need to backup
the transaction log, or else it will just keep growing. Backing up the
database does not truncate the log.
But do you need full recovery? Full recovery is needed if you want to be
able to do in point-in-time restore in case of a disaster. But if you are
content to restore the most recent full backup in that situation, you can
get along with simple recovery. With simple recovery, the log is truncated
after each committed transaction, more or less. To set the database in
simple recovery, do ALTER DATABASE db SET RECOVERY SIMPLE. Once you have
done this, you may want to reclaim some disk space with DBCC SHRINKFILE.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||you might also want to check the auto-growth feature of the log-file...
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:ONR87pPaGHA.4564@.TK2MSFTNGP03.phx.gbl...
> Win
> BACKUP LOG and then DBCC SHRINKFILE command.For more details please refer
> to the BOL.
>
>
> "Win" <aaa@.aaa.com> wrote in message
> news:eu4XxnOaGHA.4916@.TK2MSFTNGP04.phx.gbl...
>