View Single Post
Old 02-12-2008, 10:15 AM   #2 (permalink)
BlackBerry Extraordinaire
gibson_hg's Avatar
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts

Follow this article to backup and restore the database:

BlackBerry Search Results

Here are the steps I would follow:

1. Backup the db and move the besmgmt.mdf and besmgmt_log.ldf files to a safe location. This will require you to stop the MSSQLSERVER service

2. Uninstall MSDE

3. Install SQL 2005

4. Assign the permission for SQL 2005

5. Create the blank db using createdb.exe

6. Restore your backerd up over the newly created BESMgmt db

7. Point the BES to use the database on the new SQL Server 2005 instance

All the backup/restore/createdb.exe steps are in the KB above. Feel free to ask any questions.
Offline   Reply With Quote