BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-08-2006, 01:47 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: Philadelphia
Model: 7290
Posts: 67
Post Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation Knife-Edge Cutover/SQL Upgrade Question

Please Login to Remove!

Hello all.

Going to be doing a knife edge cutover to a new box in a couple weeks, and in the process we will also be upgrading from MSDE to SQL 2000 SP4

I have the standard Knife-Edge instructions, for exchage - but i dont know how the SQL upgrade factors into it, do we have to do anything extra?

Basically I have a new Windows 2003 Enterprise box With SQL 2000 SP4 Online right now just waiting. Do i just follow the standard cutover instructions, or are there extra upgrade steps we have to take?

Thanks
__________________
Matt
Blackberry 8700c
Bes 4.1 / Exchange 2003 SP2
Offline  
Old 09-08-2006, 05:43 PM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Sep 2005
Model: 8703e
Carrier: Verizon
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

how many users?
Offline  
Old 09-09-2006, 01:01 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Nov 2005
Model: 7290
Posts: 32
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sounds like you're not upgrading the MSDE, but moving the DB over? I would say, create a new database on the new SQL with server config util, or createdb (with the same name as your current DB). Then, restore your old BES DB to the new SQL, writing over the new one.

Reason...when a BES DB is created, there are some master db entries created, etc. You need to get that stuff in the new sql. Then, just cut over the BES boxes.

look at this article too:
Livelink - Redirection
Offline  
Old 09-10-2006, 10:11 PM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2006
Model: 7290
Carrier: AT&T
Posts: 23
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The database move to a new server is a snap. Just be sure that your permissions are correct. The entries that blablabla13 is refering to are entries into the sysmessages table of the master database. If those entries aren't there one of the services (can't remember which one) will not start.
Offline  
Old 09-11-2006, 03:18 AM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
BigA's Avatar
 
Join Date: Oct 2005
Location: Northern Illinois
Model: iphon
OS: 5.0.x.x
PIN: Prick
Carrier: Verizon
Posts: 421
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default

Just curious. But why SQL 2000 and not 2005?
Offline  
Old 09-11-2006, 08:12 AM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: Philadelphia
Model: 7290
Posts: 67
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

475 users, give or take.

SQL 2000 because we already have the per processor cal's paid for, management said to use 2000.
__________________
Matt
Blackberry 8700c
Bes 4.1 / Exchange 2003 SP2
Offline  
Old 09-11-2006, 08:14 AM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: Philadelphia
Model: 7290
Posts: 67
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by blablabla13
Sounds like you're not upgrading the MSDE, but moving the DB over? I would say, create a new database on the new SQL with server config util, or createdb (with the same name as your current DB). Then, restore your old BES DB to the new SQL, writing over the new one.

Reason...when a BES DB is created, there are some master db entries created, etc. You need to get that stuff in the new sql. Then, just cut over the BES boxes.

look at this article too:
Livelink - Redirection
Wel we're doing both, we're moving the DB over to a new box (which will be the new BES) and we're upgrading off MSDE.

Will a MSDE databse restore to SQL 2000 normally?
__________________
Matt
Blackberry 8700c
Bes 4.1 / Exchange 2003 SP2
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.