Re: [Bes-admins] SQL Database Move

2009-12-14 Thread Rich Fleming
Follow along with RIM's guidelines here and things should go smoothly. I've done this move several times, and downtime is very minimal. In my case, the users didn't even know it happened. (or they were just quiet about it!)

Re: [Bes-admins] SQL Database Move

2009-12-14 Thread Michael Wells
Check the docs. There are specific things you must do on the SQL server (including some scripts which modify things outside the BES DB.) Simply moving the database won't work. On Mon, Dec 14, 2009 at 8:41 AM, Gargano, Steve sgarg...@archerlaw.comwrote: For those of you who have moved their

Re: [Bes-admins] SQL Database Move

2009-12-14 Thread Sobey, Richard A
In our case, the DB move went very smoothly. However, as Michael and Rich have both asserted to, the new SQL server needs to have the BES scheme updated in its master tables or something like that. To get around that we simply allowed BES to create a new database on the destination SQL server,