Last post Sep 27, 2017 08:06 AM by Zhi Lv - MSFT
Sep 26, 2017 08:30 AM|asp.ambur|LINK
I'm very new to this concept..
Let us assume i have two table Order and Orderdetails table and i have lot of records, how do i archive my old data and if required how to restore them..
Need idea with complete code..
For example if i pass 01-Mar-2017
before data will archive to archive_order and archive_orderdetails data to table automtically and delete data in current table.
Sep 27, 2017 08:06 AM|Zhi Lv - MSFT|LINK
As far as I know, there's no general script for archiving since the rules for archival process vary depending on the business rules of the database. To overcome this types of issues, the SQL Server partition feature will be helpful to perform data archiving
in an effective manner. The main of objective of partitioning is to aid in the maintenance of large tables and to reduce the overall time to read and load data for particular user operations.
Archiving SQL Server data using partitioning