Log file is full

I have to resolve an issue with a SQL 2000 machine and need help. I am a network admin here but have never had to touch the SQL server before. I am an absolute novice regarding SQL. That being said, here's my question:
I'm getting an entry in the SQL server log that says "The Logfile for the database "dbname" is full. Backup the transaction log for the databaseto free up some log space". The next log entry reads "Error:9002. Severity:17, State:6". How do I backup my transaction log?
Thanx,
VinnyI refer you to a useful post by Andrew kelly
Either change to Simple Mode or issue regular log backups. If your are
issuing timely log backups and it still continues to grow you most likely
have an open transaction stopping the truncation. Use DBCC OPENTRAN to see.
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Vinnh H" <anonymous@.discussions.microsoft.com> wrote in message
news:9C1459C5-D481-4EBF-8D01-F449037C93A8@.microsoft.com...
> I have to resolve an issue with a SQL 2000 machine and need help. I am a
network admin here but have never had to touch the SQL server before. I am
an absolute novice regarding SQL. That being said, here's my question:
> I'm getting an entry in the SQL server log that says "The Logfile for the
database "dbname" is full. Backup the transaction log for the databaseto
free up some log space". The next log entry reads "Error:9002. Severity:17,
State:6". How do I backup my transaction log?
> Thanx,
> Vinny
>
>

Log file

I have SQL server and many people with the same account access to this
server from our network.
They access through the registration in their client enterprise manager.
Is there any option to get the IP addresses and times for connections
created to my server in last 3 months for example?
Is there any log file or any option to set that for the future access?
regards,Show about a third party tools
try ang Lumigent Log Explorer for SQL Server
http://www.lumigent.com/products/le_sql_faq.html
or the apex tools
http://www.apexsql.com/sql_tools_log.asp
"simon" wrote:

> I have SQL server and many people with the same account access to this
> server from our network.
> They access through the registration in their client enterprise manager.
> Is there any option to get the IP addresses and times for connections
> created to my server in last 3 months for example?
> Is there any log file or any option to set that for the future access?
> regards,S
>
>