Database Size or Unload Reload

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?
Reply to
ClothingStore
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 Consulting
formatting link
snipped-for-privacy@tibercreek.com----------------------------------------------Please DO NOT respond to me directly but post all responses here in thenewsgroup so that all can share the information.
> 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?
Reply to
Glenn Adams [MVP - Retail Mgmt
Thank you, I was hoping that RMS had a way to do an unload and reload for example like Sybase has. Our database shows it is almost 2GB, but I know in reality it is really only about 300MB, so for example in Sybase you can do an unload clear the log then do a reload and have your database reflect the actual size it really is, especially for backups.
> 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 Consulting >
formatting link
snipped-for-privacy@tibercreek.com ----------------------------------------------> Please DO NOT respond to me directly but post all responses here in the> newsgroup so that all can share the information.> > > > 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? >
Reply to
ClothingStore
I've read about people shrinking the log size. I think there might be an article on customersource with instructions. Craig
Reply to
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 Consulting
formatting link
snipped-for-privacy@tibercreek.com----------------------------------------------Please DO NOT respond to me directly but post all responses here in thenewsgroup so that all can share the information.
> Thank you, I was hoping that RMS had a way to do an unload and reload for > example like Sybase has. Our database shows it is almost 2GB, but I know in > reality it is really only about 300MB, so for example in Sybase you can do an > unload clear the log then do a reload and have your database reflect the > actual size it really is, especially for backups. > > >> 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 Consulting >>
formatting link
snipped-for-privacy@tibercreek.com ---------------------------------------------->> Please DO NOT respond to me directly but post all responses here in the>> newsgroup so that all can share the information.>> >> >>> 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?
Reply to
Glenn Adams [MVP - Retail Mgmt
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...
Reply to
Danny
Not sure I want to go to 2.0 yet - don't like the way licensing works... Anyway to do this with 1.3
Danny
Reply to
Danny

Site Timeline Threads

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.