Monday, March 19, 2012

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
>
>

No comments:

Post a Comment