I have a database that is not going to be used anymore but that needs to be kept around for a long time. I'd like to remove it from the production system. My goal is to save storage space when archiving that database. I need to preserve it at full fidelity, so a BCP export is not good enough. I also would not trust generated SQL scripts to preserve it fully.
- Take an uncompressed backup and compress it using 7-Zip.
- Detach the database and compress the MDF and LDF files using 7-Zip.
Is option 2 safe? Which one is preferable? What are important considerations here?