Applies to Product - Dynamics 365 Lifecycle Services
What’s happening?
Customers are seeking assistance with obtaining database backups or restoring databases in various environments, including production and development. Specific inquiries include how to reduce database size for export and the availability of backup logs or reports.
Reason:
- The database movement operations can manage a full database but not individual tables. There are limitations in tracking production database backups, and certain reports may not be available for sharing.
- The size of the database can impact restoration processes, especially when space is limited in the target environment.
Resolution:
- Obtaining Database Backups:
- Use the Lifecycle Services (LCS) to perform database movement operations. This includes using the "Refresh database" option to copy the production database to a sandbox environment.
- Enable just-in-time database access to connect to the sandbox database and extract the required data.
- Reducing Database Size for Export:
- Follow the guidelines provided in the documentation for exporting a database, which includes cleanup routines to reduce the database size.
- Refer to the following resources for detailed steps:
- Backup Logs and Reports:
- Currently, the production backup log/SOC report is not available for sharing. Discussions are ongoing with senior management regarding the availability of these reports in the future.
- Restoration Issues:
- If restoration fails due to space issues, consider truncating large tables or applying cleanup routines to reduce the database size before attempting the restoration again.
- General Advice:
- Schedule database operations during off-peak hours to minimize impact on users and ensure successful completion of long-running operations.