Advertisement

01.09.2008 at 06:18AM PST, ID: 23069420
[x]
Attachment Details

cannot truncate log file - all logical files in use

Asked by GreshAssoc in Databases Miscellaneous, MS SQL Server

Tags: , ,

I have a 6GB database with a log file that is now 54GB.  Maintenance plans are scheduled to backup the DB and truncate the log files, they appear to be successful according to history.  I have also backed up the db and the trans with truncate_only via QA.  Results to text when doing the dbcc shrinkfile return: Cannot shrink log file 2 (EnterpriseJournalStoreLOG70) because all logical log files are in use.  DBCC Opentran returns: Replicated Transaction Information:
        Oldest distributed LSN     : (0:0:0)
        Oldest non-distributed LSN : (619303:35422:1)

DBCC Loginfo returns about 600 rows all with a status of 2, and the first 18 results have 0 listed for CreateLSN, the rest of them return a number.
I have manually reindexed as well and cannot get this thing to shrink / commit.  The database has been switched to Simple recovery mode for troubleshooting purposes, and the DB is not replicated / no trans log shipping.

I have exhausted the internet and this KB over the past 4 days, and am not sure where to go next short of call MS.Start Free Trial
 
Keywords: cannot truncate log file - all logical file…
Title
1 Help... TRUNCATE... DBCC SH…
2 DBCC REINDEX
3 reindexing sysobjects
4 dbcc reindex writing to table
5 Why does DBCC DBREINDEX NOT impr…
6 dbcc reindex
 
Loading Advertisement...
 
[+][-]01.09.2008 at 06:23AM PST, ID: 20618307

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 06:28AM PST, ID: 20618363

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 06:59AM PST, ID: 20618644

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 01:38PM PST, ID: 20622739

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 01:50PM PST, ID: 20622845

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 02:04PM PST, ID: 20622979

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 05:28AM PST, ID: 20626903

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 06:12AM PST, ID: 20627203

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 10:47AM PST, ID: 20629792

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 10:54AM PST, ID: 20629853

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 11:14AM PST, ID: 20630034

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 11:27AM PST, ID: 20630156

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.14.2008 at 09:10AM PST, ID: 20654530

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]01.14.2008 at 11:40AM PST, ID: 20655971

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.16.2008 at 06:25AM PST, ID: 20672103

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.16.2008 at 11:58AM PST, ID: 20675445

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Databases Miscellaneous, MS SQL Server
Tags: Microsoft, SQL, 2005
Sign Up Now!
Solution Provided By: dtodd
Participating Experts: 4
Solution Grade: B
 
 
[+][-]01.16.2008 at 12:26PM PST, ID: 20675716

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628