BlackBerry Forums Support Community

Closed Thread
LinkBack Thread Tools
Old 11-28-2006, 02:57 PM   #1 (permalink)
New Member
Join Date: Sep 2006
Model: 7750
Carrier: Cingular
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving BB SQL 2000 DB

Please Login to Remove!

We are running BES 4.0 on a Windows 2000 server. Our BES SQL 2000 db is located on another Windows 2000 Server. We have to return the current SQL server and I would like to move the BES SQL db to a different server. I have backed up and restored the BES SQL db to the new server. When I attempt to point the db to the new server using the Blackberry Server Configuration Tool, I receive "db upgrade failed". Are there specific steps for moving a BES SQL DB?
Old 11-28-2006, 03:37 PM   #2 (permalink)
CrackBerry Addict
|||||||'s Avatar
Join Date: Jun 2006
Model: 7100
Carrier: Rogers
Posts: 615
Post Thanks: 0
Thanked 0 Times in 0 Posts

Make sure the account you are using has db_owner and Server administrator in SQL while you are doing the move.

Copyright 2004-2016
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.