I have a database that is almost 2GB which is not a bid deal but a lot of data has been removed and changed years ago. Does RMS have a way to do like a unload and reload which would put the database back to size it should be?
No, there is no built in Archive functionality, but Retail Realm has an add-in that does this. Check with your RMS reseller for more information. It's possible to clear old records without a utility, but there is a lot of room for error - an existing, tested solution is the smart way to go...
Glenn Adams Tiber Creek C> I have a database that is almost 2GB which is not a bid deal but a lot of
I've read about people shrinking the log size. I think there might be an article on customersource with instructions. Craig
MS SQL Server splits it's data and log into separate files (.mdf for data, .ldf for log). Both files will auto-grow as needed in a default configuration. I'm not sure where you are looking to get the size, but it is probably pretty close to 2 GB of real data. This is a problem if you are using MSDE, as the max database size is 2GB; if you use SQL Server 2005 Express the limit is 4GB and for the 'full' versions (the ones that you have to pay for) there is no enforced limit. You will generally not have more than about 10% free space in the data file unless you delete old records (by archiving as I mentioned before).
Glenn Adams Tiber Creek C> Thank you, I was hoping that RMS had a way to do an unload and reload for
Is there a KB on upgrading from MSDE to SQL Server 2005 Express?
Danny "Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP02.phx.gbl...
If you upgrade to 2.0 it will upgrade you to Express automatically. Craig
Not sure I want to go to 2.0 yet - don't like the way licensing works... Anyway to do this with 1.3
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.