Sample Header Ad - 728x90

Transaction log file - Migration SSMA

1 vote
0 answers
79 views
I'm attempting to migrate a relatively large Oracle DB to MSSQL using SSMA however due to disk space constraints, I had to stop the full migration last night when it was 50% of the way through. data_usage Upon investigating disk space usage, I've found that the transaction log file is nearly 3x the size of the data files. Is there any way I can get this down? Would you recommend deleting the new DB and starting again from scratch? Would the Transaction log file have normalised in size if I let SSMA complete the migration? I've tried shrinking the txn log to no avail. Any help here is appreciated. Cheers Mark
Asked by Mark Treanor (11 rep)
Oct 1, 2020, 08:48 AM