cancel
Showing results for 
Search instead for 
Did you mean: 

Is any way to disable SQL Server transaction log while importing the TR

SAPSupport
Employee
Employee
0 Kudos

As we are trying to import the TR into the system my SQL Server transaction log get full and my system get down
so kindly suggest is any way we are disable my sql log while importing the TR.


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

You can't do without transaction logs in SQL Server, under any circumstances. 

You can set recovery model to SIMPLE for non-production environment or enable autogrow function to let transaction log file automatically increased.  

For more details for the solution of transaction log full, please go through SAP Note 421644 - SQL error 9002: Transaction log is full.

Best regards,
SAP Support