Overly inflated log file on target database
SQL_ME_RICH
Posts: 112
Hello -
Syncing a single table from my source database to my target database is blowing up my target database's log file to over 2.5X the size of the data being transferred.
My table is just over 180 GB in size (data is around 90 GB and indexing is around 90 GB). My target database is in simple recovery mode, and my Infrastructure team is ready to kill me (because I keep having to expand the disk that my target database's log file resides on). I'm 24 hours into this process, and I'm not sure that it's going to make it. I estimate at least another 24 hours before it completes, and at the rate the log file is continuing to grow - I'm going to come up short.
Is this normal? I am having to populate the table completely from the source (for reasons I will not bore you with), but I am having a hard time understanding why the log file has exploded in its size.
Any insight will be much appreciated.
Syncing a single table from my source database to my target database is blowing up my target database's log file to over 2.5X the size of the data being transferred.
My table is just over 180 GB in size (data is around 90 GB and indexing is around 90 GB). My target database is in simple recovery mode, and my Infrastructure team is ready to kill me (because I keep having to expand the disk that my target database's log file resides on). I'm 24 hours into this process, and I'm not sure that it's going to make it. I estimate at least another 24 hours before it completes, and at the rate the log file is continuing to grow - I'm going to come up short.
Is this normal? I am having to populate the table completely from the source (for reasons I will not bore you with), but I am having a hard time understanding why the log file has exploded in its size.
Any insight will be much appreciated.
Comments
Error: Synchronization of 'MySourceServer.MySourceDatabase' and 'MyTargerServer.MyTargetDatabase' failed: An attempt was made to move the file pointer before the beginning of the file.
Have looked and searched out here, but am not finding reference to this error. Need support on this please, thanks.