I’m automating a large Archiving\Purging script on 1TB multi-databases.
I run all Sp’s from Archive database (Destination database).
The log file gets full fast in both source and destination databases and the whole process stopped, I have to clear all log files, as well I have to
shrink file after clearing it.
View Complete Post