BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-26-2007, 12:29 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2005
Location: Atlanta
Model: 9000
Carrier: AT&T
Posts: 85
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Failover issue

Please Login to Remove!

Hello.
I have two blackberry servers using a third server for the database (SQL 2005 Express), I also have for failover purposes a secondary SQL 2005 Express server which receives and installs daily a copy of the BESMgmt database. Recently I had the primary SQL server crash. When pointing the two BES servers to this database I get errors like below

08/25/2007 08:03:03 PM RIMGateUserDB::SyncUserMailUpdate: COM Error 0x80040E14 - Source: 'Microsoft OLE DB Provider for SQL Server' - Description 'Error 70000, severity 10, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.' - Command ' UPDATE UserConfig SET ServerDN = ?, MailboxDN = ?, MailboxSMTPAddr = ? WHERE Id = ?'
08/25/2007 08:03:14 PM RIMGateUserDB::SyncUserMailUpdate: COM Error 0x80040E14 - Source: 'Microsoft OLE DB Provider for SQL Server' - Description 'Error 70000, severity 10, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.' - Command ' UPDATE UserConfig SET ServerDN = ?, MailboxDN = ?, MailboxSMTPAddr = ? WHERE Id = ?'

Any ideas?
Offline  
Old 08-26-2007, 12:59 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

When you setup the 2nd database server did you simply just copy the database over or did you use the createdb.exe command to create a database shell and then copy the database over?

The latter would be the proper procedure.
Offline  
Old 08-26-2007, 05:58 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2005
Location: Atlanta
Model: 9000
Carrier: AT&T
Posts: 85
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
When you setup the 2nd database server did you simply just copy the database over or did you use the createdb.exe command to create a database shell and then copy the database over?

The latter would be the proper procedure.
Yes I am using the following
sqlcmd -S "ServerName" -U sa -P password -i "path to a sql file" containing
BACKUP DATABASE BESMGMT TO DISK and a path to where I want the .bak created. I then have that file copied to the other server (Normal Copy Process) and run a the above command with its sql file containing RESTORE DATABASE BESMGMT FROM DISK. <-THis is done daily at 6am.
Offline  
Old 08-26-2007, 07:06 PM   #4 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sure that is good for doing the daily procedure, but the first thing that should have been done was to create a database shell and then restore over that.

Just having the database isn't good enough. When you install BES, information is written to other parts of the database server. Jobs are created, and information is published to the master database ... running the createdb.exe command will create the required entries in the master database.

I would recommend deleting the database from server you're replicating to; run the createdb.exe besmgmt.cfg (after you modify the besmgmt.cfg file) on the failover sql server, and then restore your backup you're making. These messages should then stop.
Offline  
Old 08-27-2007, 08:23 AM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2005
Location: Atlanta
Model: 9000
Carrier: AT&T
Posts: 85
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
Sure that is good for doing the daily procedure, but the first thing that should have been done was to create a database shell and then restore over that.

Just having the database isn't good enough. When you install BES, information is written to other parts of the database server. Jobs are created, and information is published to the master database ... running the createdb.exe command will create the required entries in the master database.

I would recommend deleting the database from server you're replicating to; run the createdb.exe besmgmt.cfg (after you modify the besmgmt.cfg file) on the failover sql server, and then restore your backup you're making. These messages should then stop.

Thanks I will do so
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.