BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 08-09-2005, 10:02 AM   #1 (permalink)
mkb
Knows Where the Search Button Is
 
Join Date: Mar 2005
Posts: 46
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Database Problem

Please Login to Remove!

I ran into some major corruption in my SQL Database (long story) and received the horrible news from our DBAs that the backup utility has not run on the SQL server since...gulp...May. I tried to recreate a database from scratch using the createdb command and then I did a command line user migration to populate the database. This seemed to be working well until I discovered that I am no longer able to push IT policies to any of the devices. TSupport told me that the only way I could correct the issue was to completely wipe and then reactivate each device. There are over 500 of them. It seems that the only table that was really corrupted was the userconfig table. Does anyone have any suggestions or even wild guesses as to how I can correct this problem without going through 500 manual wipe and reactivations? Is there a field/table/etc. from the previous database that I could copy into the new DB to make the IT policies work? (Assuming they weren't corrupted) A service book I could delete? Anything? Any ideas on how to restore the DB back to how it was 2 days ago?

I am running BES 4.0 SP1 HF3 in a Domino environment.
Offline  
Old 08-09-2005, 12:41 PM   #2 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

a security wipe is the only way to bypass this issue. sorry. i had to do the same, but on a much smaller scale.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
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

Vintage Very Good Hickok DEC 720 Decade Resistance Box 1 to 999,999 Ohms
$50.0
Vintage Very Good Hickok DEC 720 Decade Resistance Box 1 to 999,999 Ohms pictureVINTAGE CONTINUUM PUMPED LASER CAVITY MODEL 711-06 S/N 677-DEC 1993-UNTESTED
$149.99
VINTAGE CONTINUUM PUMPED LASER CAVITY MODEL 711-06 S/N 677-DEC 1993-UNTESTED pictureVintage Dec Digital H775d Remote Battery Backup 35v 1.5a D.C.
$5.95
Vintage Dec Digital H775d Remote Battery Backup 35v 1.5a D.C. pictureVINTAGE CATERPILLAR D6 TRACTOR PARTS CATALOG MANUAL 74 INCH GAUGE DEC 1953 CAT
$9.0
VINTAGE CATERPILLAR D6 TRACTOR PARTS CATALOG MANUAL 74 INCH GAUGE DEC 1953 CAT pictureVintage Pelouze Scale Model Y50 50 lb x 2 oz DEC 31, 1975 Postal Scale
$23.96
Vintage Pelouze Scale Model Y50 50 lb x 2 oz DEC 31, 1975 Postal Scale picture






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