asked on
Error Occured in :Loln_spodcamtcalculationMessage : The transaction log for database 'SHRICITYREPORT' is full due to 'LOG_BACKUP'. Rollback Succesfully
Hi Experts iam using temp db in my sp after completing my work at the end of my sp am deleting that temp table.
Now i got a problem while running my sp for some 5 lakhs records at the end am getting the error log msg as
Error Occured in :Loln_spodcamtcalculationM
how can i avoid the error how to handle in my sp. am attaching my sp
09.Loln_spOdcAmtCalculation.sql
Now i got a problem while running my sp for some 5 lakhs records at the end am getting the error log msg as
Error Occured in :Loln_spodcamtcalculationM
how can i avoid the error how to handle in my sp. am attaching my sp
09.Loln_spOdcAmtCalculation.sql
DatabasesMicrosoft SQL Server
Last Comment
Vitor Montalvão
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Why? As said, it is an external constraint. Further, temp tables are part of TEMPDB, and that never receives a transaction log backup, so cannot be the issue. The error message clearly tells you that your issues are with the main DB.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Execution-plan-March.sqlplan
09.Loln_spOdcAmtCalculation.sql