Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the database archive procedures?

April 26, 2017archive database procedures

0

10 Posted

What are the database archive procedures?

1 Answer

0

10 Posted

A. Audits can be marked as archived, which removes them from the default views. Deletions are marked as deleted, not physically deleted from the database, which enables a full history to be held. If a separate database archive is required, the recommended approach is to use SQL Server to backup the database and restore it under a different name, then clean up the data on either side as desired by using the administration tools provided within the application.