Re: [Mssqlcompressed-users] Transaction Log space concerns

[João C. P. <jc...@eu...>]

Hi there,

Indeed the use of bzip2 plugin with msbp slows down the backup to nearly 8  
hours instead of 45m without it. So the backup produces a lock with  
ACTIVE_TRANSACTION in log_reuse_wait_desc with transaction log growing to  
near 12GB.

Thanks and best regards,
-- 
João C. Pinto <jc...@eu...>
Eurotux Informática, S.A.

Em Fri, 23 Dec 2011 11:33:47 -0000, Clay Lenhart <cl...@le...>  
escreveu:

> It is highly unlikely that msbp is causing this. Next time look at the
> log_reuse_wait_desc column in sys.databases to see why so much log space  
> is
> needed. Msbp utilizes the same backup architecture that SQL Server uses  
> so
> it shouldn't be any different. One possile explaination is if you slow  
> down
> the backup using the "rate" plugin provided with msbp. SQL Server will  
> keep
> transaction log records until the backup completes (this is true no  
> matter
> which backup method you use). This sounds far-fetched though since the
> transaction log is over 35GB. You'd have to *really* slow down the  
> backup.
>
> There are several reasons, unrelated to backups, why transaction log
> records are not purged. Definitely query that column to see what is going
> on.
>
> On Wednesday, 14 December 2011, João C. Pinto <jc...@eu...> wrote:
>> Hi,
>>
>> First of all, thanks for sharing a great tool that already proved to be
>> very useful.
>>
>>
>> When trying to make a backup through MSBP to a 35GB BD in simple mode I
>> get the following error:
>>
>> 07:34:29 ------------------------ Exception #1 The transaction log for
>> database 'MV.Web' is full. To find out why space in the log cannot be
>> reused, see the log_reuse_wait_desc column in sys.databases BACKUP
>> DATABASE is terminating abnormally. Processed 3806968 pages for database
>> 'MV.Web', file 'MV.Web' on file 1. Processed 268653 pages for database
>> 'MV.Web', file 'MV.Web_log' on file 1.  
>> System.Data.SqlClient.SqlException
>> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>> Boolean breakConnection) at
>>
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
>> stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior  
>> runBehavior,
>> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>> bulkCopyHandler, TdsParserStateObject stateObj) at
>> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
>> RunBehavior runBehavior, String resetOptionsString) at
>> System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader() at
>> System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult
>> asyncResult) at MSBackupPipe.Common.SqlThread.EndExecute() in
>> C:\Users\Clay\Documents\MSSQL Compressed\mssql
>> sourceforge2\MSBackupPipe.Common\SqlThread.cs:line 492 The backup  
>> failed.
>> Below are the commands for msbp.exe: msbp.exe help msbp.exe backup
>> msbp.exe restore msbp.exe listplugins msbp.exe helpplugin msbp.exe  
>> version
>> For more information, type msbp.exe help <command>. Process Exit Code 0.
>> The step succeeded.
>>
>> After allowing the transaction log to auto-grow without any limit the
>> backup successfully completes with the transaction log growing to near
>> 12GB. However, if the backup is normally done with a maintenance plan
>> through SQL Server, the transaction log never gets higher than 2 or 3GB.
>>
>> Is there any reason to this? Can I make a backup without transaction log
>> taking so much space?
>>
>>
>> Best regards,
>> --
>> João C. Pinto <jc...@eu...>
>> Eurotux Informática, S.A.
>>
>>
> ------------------------------------------------------------------------------
>> Learn Windows Azure Live!  Tuesday, Dec 13, 2011
>> Microsoft is holding a special Learn Windows Azure training event for
>> developers. It will provide a great way to learn Windows Azure and what  
>> it
>> provides. You can attend the event by watching it streamed LIVE online.
>> Learn more at http://p.sf.net/sfu/ms-windowsazure
>> _______________________________________________
>> Mssqlcompressed-users mailing list
>> Mss...@li...
>> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>>