MSDE - Need fast help - Need to move BES MSDE datastore to a new server with MSDE - Need to Know how to do this
Posted on 2007-11-13
I built a new BlackBerry BES Server on W2k3 with all that patches etc.
I installed BES software, and it created a new MSDE instance that I mapped to the "D" drive. This is important because the default location is c:\program files\mic.....\SQL....\Data. I can't have the DB reside in the default location. It needs to be on the new data partition that I created "D". I tried to cold copy the data files with the services off, and when they come back on they fail to log in.
I tried to use SSIS in SQL Server studio to import/export a lot and it fails to do it because there are already instances of Views and other objects in the destination DB.
How can I attached a copy of the old MSDE data store to the new MSDE datastore using OSQL or something like that?
I rather use Studio, but it's not allowing remote mapping of the data files.
Please help and fast (o: