I posted a howto on this a while ago. Search for it in my older posts and you should easily find it.
160 users is quite a lot for MSDE.
My howto ran through how to upgrade from a single BES installation hosting BES and MSDE on the same box to a dual-server setup running SQL and BES on separate boxes.
The MSDE and SQL databases work on both. So basically setup the new systems but don't turn them on. Shut the old BES down. Migrate the database to the new SQL server and make the appropriate changes for server and instance names. Bring the new database online. Bring the new BES server up and point it to the new database. Start BES services.
Took about 30 mins to do all of that once the servers were built and ready to go. Users hardly saw any downtime, and most didn't even notice. The differences in delivery time and updates is phenomenal and the migration process is fairly simple.
|