Home Page link  

Max database size

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Max database size Alex 08-04-2008
Posted by Alex on August 4, 2008, 4:20 pm
Please log in for more thread options
 HELLO Guys.
Our main office server using HQ RMS 2.0 and 12 stores are connected.
I found out 2gb is max size for RMS database from here.
Since our HQ database reaching 2gb, I decide to purchase full version
of SQL 2005.
However I am not sure which version I have to purchase.
Can I buy standard version with 5 cal? (I am not sure about 'cal')
Should I purhcase 7 more 'cal' to run 12 stores?
Please be advised.

Posted by Matt Hurst on August 5, 2008, 12:45 am
Please log in for more thread options
 You will need to purchase one copy of Headquarters Client for each store that
will connect to the Headquarters database. Activation is not required to run
Headquarters Administrator, Headquarters Server, or Headquarters Manager, so
you can install Headquarters on as many machines as you want at your
Headquarters location.
Instead of full SQL, you may want to consider SQL Server 2005 Express
Edition which is included on your Headquarters CD. The maximum database size
has been increased to 4 GB.

"Alex" wrote:

> HELLO Guys.
> Our main office server using HQ RMS 2.0 and 12 stores are connected.
> I found out 2gb is max size for RMS database from here.
> Since our HQ database reaching 2gb, I decide to purchase full version
> of SQL 2005.
> However I am not sure which version I have to purchase.
> Can I buy standard version with 5 cal? (I am not sure about 'cal')
> Should I purhcase 7 more 'cal' to run 12 stores?
> Please be advised.
>

Posted by Alex on August 5, 2008, 10:09 am
Please log in for more thread options
Hello Matt.
Thank you for the advise.
Do I have to install SQL server 2005 express edition manually?
Or does it automatically installed when I upgraded HQ from version 1.3
to version 2.0?
I shouldn't get database size warning message if it is installed
automatically but I got max DB size warning message when it almore
reach 2GB (It was resolved after I delete old receipt file)
Please be advised.
thank you.

Posted by Matt Hurst on August 5, 2008, 12:22 pm
Please log in for more thread options
yes, installing HQ from the disk on the machine that the MSDE is located will
prompt you to upgrade to 2005 Express. Make sure to create a backup before
you upgrade because the process will convert your database and there is no
downgrade proceedure if you change your mind.
If you are also upgrading the version from 1.3 there are other procedures to
follow to upgrade the data source from 1.3 to 2.0 including the stores. Read
and follow the documentation. If you are faint of heart, get qualified
assistance from your vendor.
When I tried 2005 Express with SO, I found data problems similar to the fix
just realeased for RMS2.0 with XPsp3 or Vista SP1. Since upgrading the OS
and installing the latest patch, I haven't seen those problems.
See
https://mbs.microsoft.com/customersource/support/selfsupport/hottopics/RMS_XP_SP3_VISTA_SP1_Compatibility.htm

"Alex" wrote:

> Hello Matt.
> Thank you for the advise.
> Do I have to install SQL server 2005 express edition manually?
> Or does it automatically installed when I upgraded HQ from version 1.3
> to version 2.0?
> I shouldn't get database size warning message if it is installed
> automatically but I got max DB size warning message when it almore
> reach 2GB (It was resolved after I delete old receipt file)
> Please be advised.
> thank you.
>

Posted by Alex on August 7, 2008, 10:56 am
Please log in for more thread options


Hello Matt.
Thank you very much for your advise

Similar ThreadsPosted
Database Size July 26, 2005, 8:38 am
Database Size August 8, 2005, 12:13 pm
Database Size August 8, 2005, 12:13 pm
Database Size August 8, 2005, 12:15 pm
RMS 1.2 database size August 27, 2005, 12:07 pm
Database size December 14, 2005, 4:56 am
Database size? December 18, 2005, 2:39 am
RMS Database Size April 17, 2006, 9:29 pm
Database size June 25, 2007, 11:47 am
401 and HQ Database size June 25, 2007, 2:27 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap