1. Home
  2. Point-Of-Sale Software
  3. 2003 server upgrade

2003 server upgrade

Last night I installed SCSI drives on my server and loaded Windows 2003 server on these RAID drives. I am currently running RMS on an XP platform using an IDE drive. Once I loaded server and raided the drives, I swapped back to the IDE drive so the store could open this morning.

My questions are: Once I get server 2003 networked, what is the step by step process to load RMS and restore my items DB? Would it benefit me to load a better version of SQL (SQL 2000 as opposed to MSDE) and what does that involve? Do you recommend using a flash drive to capture store management files (non RMS) and backup and restore the items DB?

I appreciate any and all input as I want this to go as smoothly as possible. One more question. Will I notice an improvement with the DB and POS application running on a true server backbone?

Thanks again!

Reply to
zoostation
Loading thread data ...

zoo,

Backup your RMS db onto a CD/DVD, flash, floppy, networked drive, etc.

Install RMS onto the new drives, restore the RMS db from your backup above and setup your 2003 Server security.

Full version vs. MSDE -> how many stations are hitting it? Registers vs Managers? Standalone vs HQ, If HQ, how many stores? How big is your db now as MSDE is limited to 2 gig, 1.3R with SQL2K5E allows for 4 gig. All other versions of SQL are unlimited.

Flash is fine if big enough, Why not just create a share on a workstation's drive and copy to it, then from it after the switchover?

Maybe, maybe not. Depends on the above answers and your configuration.

Hope you are giving the server lots o' RAM!

Reply to
Jeff

Jeff, It's a standalone store with 1 server and 2 registers. DB is up to about a gig.

Are there certa> zoo,

Reply to
zoostation

zoo,

Why are you doing this for such a small operation? If you've got all this extra cash lying around, send it to me!! ;-))

We _regularly_ connect up to 10 stations on a dedicated XPP machine without issues. Server has 2-4 gig of RAM, SATA RAIDed drives, MSDE/SQL2K5E or SQL2K/SQL2K5 Workgroup Edition.

Up to 5-6 stations with a _non-dedicated_ XPP machine.

Same with some small multistore (3-5) operations.

Nothing too special with RMS ->W2K3 Server, just normal installs, shares, etc.

Make sure you have CALS (more $) for the workstations too!

Reply to
Jeff

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.