Situation is as follows:

Server 2003 running on VMware Server with BPS 4.1.4 installed. This was a temporary solution because the office purchased a new server to implement SBS2008. Since BPS can't run on Server 2008, I went to the VM approach.

The old office server has now been reloaded to Windows 2003 and I want to get off the VM (because it's on a slooow desktop). I don't want to have to re-activate handhelds, I'd like to just move the database.

My plan is to install BPS 4.1.4 on the physical Windows 2003 box and migrate the MSDE DB.

I've found this article, which covers moving from MSDE to a remote SQL Server.

View Document 0 87221896

It's a basic concept. Backup and Restore or detatch/re-attach BESMgmt database. I'm going to be using the exact same folder structure from the Server 2003 VM to the Server 2003 physical box, so I was pkanning to do detatch/re-attach approach.

Should this work without any issue?

Do a knife edge cutover.


here are my notes
Bored, so might as well do what I recomend so often, The Knife Edge Cutover

Your process indicates you are using remote SQL. If I was doing that, I wouldn't have asked the question, since there's not much to do when the DB location isn't changing.

I am using MSDE on the current box, and will use MSDE on the new box.

Did you look at task 3 in the link provided in my notes?

It covers both MSDE and SQL.

Either way it is about the same except for the database part.