[Mssqlcompressed-users] Transaction Log space concerns

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

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.