Error message showing the log file for database is full

Hi,
I am working with a sql server 2000 database where it says the log file for
the database accounting is full. It also says to back up the transaction lo
g for the database to free up some log space.
My question is:
1) Is is necessary to make a transaction log backup on a regular basis?
2) Is there any chance of corrupting the database by trying this process? At
present due to shortage of space there is no backup of the production datab
ase.
Thanks in advance> 1) Is is necessary to make a transaction log backup on a regular basis?
We cannot dictate your backup strategy, only you can. I prefer to do both da
tabase as well as log backups, in
general. If you don't want to do regular log backups, just set the recovery
model to simple! Read about
recovery models in books online.

> 2) Is there any chance of corrupting the database by trying this process? At prese
nt due to shortage of
space there is no backup of the > production database.
What do you mean by "trying this process". If you specify what that mean, we
can probably comment on that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <John@.discussions.microsoft.com> wrote in message
news:A5765959-98BD-4995-8401-6AC07B5A4311@.microsoft.com...
> Hi,
> I am working with a sql server 2000 database where it says the log file for the da
tabase accounting is full.
It also says to back up the transaction log for the database to free up some log space.[vbco
l=seagreen]
> My question is:
> 1) Is is necessary to make a transaction log backup on a regular basis?
> 2) Is there any chance of corrupting the database by trying this process? At prese
nt due to shortage of[/vbcol]
space there is no backup of the production database.
> Thanks in advance