Moving Large Number of Records between Databases Involved in AlwaysOn.
Moving data from Transaction database to Archive/Reporting database. After the records has been moved, delete the records to avoid duplicates. Note: If your database is involved in AlwaysOn or in Full Recovery mode, make sure you backup the database and log file to clear out the log files on the database before preceding. After you... » read more