Applies to: 64-bit SQL Server installed on a 64-bit Windows operating system
Use the SQL server database archiving feature to archive an SQL table, based on specific archival criteria.
The archive process exports data from the source database to a staging database. The staging database must reside on a different SQL Server instance on the same or a different client. To complete the archive process, the exported data is backed up.