Also in my event log I've gotten alot of

Object reference not set to an instance of an object.[ at BVSoftware.Bvc5.Core.Orders.Order.GetHandlingAmount(Order order) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Orders\Order.vb:line 1881 at BVSoftware.Bvc5.Core.BusinessRules.OrderTasks.ApplyHandling.Execute(OrderTaskContext context) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\BusinessRules\OrderTasks\ApplyHandling.vb:line 13 at BVSoftware.Bvc5.Core.BusinessRules.OrderTask.Execute(TaskContext context) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\BusinessRules\OrderTask.vb:line 7 at BVSoftware.Bvc5.Core.BusinessRules.Workflow.Run(TaskContext c) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\BusinessRules\Workflow.vb:line 59 ]

FYI... I downloaded the image upload fix

procedure: bvc_Order_s line: 12 Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Exception: System.Data.SqlClient.SqlException: procedure: bvc_Order_s line: 12 Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteDataSet(DataRequest request, Int32 startRowIndex, Int32 maximumRows, Int32& rowCount) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 127

Example I used

Complete Transaction Log File Rebuild

If none of the above SQL shrink log file methods work, you can create a brand-new empty transaction log file (and delete the current log file which is renamed later when satisfied with db operations) the following way:

Assume the database name is dbOMEGA;

Exit all users from the database

Backup database dbOMEGA

In SQL Server Management Studio Object Explorer:

Right click on dbOMEGA -> Properties -> Files -> make note of the PATHs for .mdf and .ldf

Select dbOMEGA -> Tasks -> Detach... -> Click on OK

In the log file folder for dbOMEGA (from Properties) -> rename the dbOMEGA_log.ldf to dbOMEGA_log_to_be_deleted.ldf

Click on Databases in OE -> Attach... -> Click Add -> add the database dbOMEGA .mdf file (MDF file location), select the log file and click on the REMOVE button, click on OK at the bottom

After verifying and using the database with the new transaction log, the old log file can be deleted (like a week later)