Solved

Tlogs Full no drive space left

Posted on 2006-11-14
5
399 Views
Last Modified: 2008-03-10
Hi,

The Tlogs are full and the backup drive can't handle the size when being back-up and the backup process of TLogs fails everytime.

ms sql 2000

any idea's how to go about this?


Thanks.
0
Comment
Question by:FrankPorter
  • 2
  • 2
5 Comments
 
LVL 29

Expert Comment

by:Nightman
ID: 17945102
Make space available on the back drive first or backup to a different drive
0
 

Author Comment

by:FrankPorter
ID: 17945136
problem is there's not enough space available.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17945140
1. Enable Auto grow    right click on ur database -> properties -> select 'transaction log ' tab  -> check "automatically grow"
   Also make sure that there is enough space

2. Take regular transaction log backups

read the following article
http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 300 total points
ID: 17945146
you can clear your transaction log using

BACKUP LOG <urDBName> with TRUNCATE_ONLY
0
 
LVL 29

Assisted Solution

by:Nightman
Nightman earned 200 total points
ID: 17945168
Note: running BACKUP LOG 'dbname' with TRUNCATE_ONLY will truncate the log and not back it up - any data that has been checkpointed (i.e. committed and then written to the mdf) will be cleared (existing uncommitted transactions will not be!).

This means that you should then perform a full backup of your database, as you have just cleared the transaction log, making those transactions 'unrecoverable' from future transaction log restores (as they essentially don't exists!)
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sqlquerystress - To test db performance 8 42
SQL Replication question 9 43
SQL View nearest date 5 37
Insert query into temp tables using Coldfusion 3 22
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question