We have a SQL 7 database that is no longer actively used, however due to the lack of business involvement, we can't take the risk of just deleting the database. We can't keep it running on SQL7 as we are at last upgrading from that version.
So we need to 'archive' it on to another format. We tried Access (97 is the only ver available to us) but the the data is bigger than the 2gb size limit of mdb's.
I was think about SQL compact as the 4gb limit would be enough.
Any other suggestions?
View Complete Post