I have a Microsoft SQL database that's over 100gb currently in service. It's due to be decommissioned but I want to keep the data for occasional use without paying for a Microsoft SQL licence (currently provided as part of a monthly subscription by my server provider). Unfortunately Microsoft SQL express has a size limit that is much lower than my database size. What options do I have for retaining this data for only occasional use by a single user?
Sql-server – How to backup a large (100gb+) microsoft sql database for occasional “offline” use
backupsql server
Related Question
- Sql-server – SQL Server Database Mirroring is going to die. How to guarantee high availability now
- Sql-server – Possible Sign That A Database Is Corrupt
- Overcoming SQL Server Express Edition Limitations
- SQL Server 2012 – How to Manage Log File Size in Large, Heavy-Use Database
- Sql-server – how can I ensure database connectivity on a spotty network? (and allow for entirely offline connectivity)
- SQL Server – How to Use Minimal Database File Space to Rebuild an Index on SQL Server Express
Best Answer
If the primary goal is to save money (i.e. not licensing Standard, let alone Enterprise, edition) you’ll need to be creative and accept a certain amount of inconvenience. Some ideas: