BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-07-2011, 10:58 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2006
Location: Milford Conn
Model: 9530
OS: 5.0.0.328
Carrier: verizon
Posts: 69
Post Thanks: 6
Thanked 0 Times in 0 Posts
Default How much downtime when converting SQL 2000 to SQL server

Please Login to Remove!

I have 2 VM's (ver 5 MR02) called bberry01 and 02 with 150 users. Since I am using SQL2005 they are not really hot spares. I just use 02 as a backdoor way into besadmin. I have backed up my besmgmt database and given it to my SQL expert who followed the instructions and restored it easily using the Blackberry instructions. We were able to open all the tables, see the information, etc so the procedures are good.
Summer is a time when i can take the system down a bit and convert to SQL. The directions seem to say(roughly)- backup besmgmt, stop the services, migrate the backup to SQL, stop all sevices and point the database to the SQL server. That would "seem" to take only about 20 minutes. The question is
a.) Could i do the Besmgmt backup and convert an hour or so ahead of time? Would I miss any transactions(I dont think so).
b.) How soon would the devices work after i pointed them to the new SQL server.

The strange thing is that everything works so well now i am afraid to do it. However if I had a hot spare(using SQL) i could do service pack and MR upgrades easily without downtime.
Any advice would be appreciated.

Thanks
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

Similar Threads for: How much downtime when converting SQL 2000 to SQL server
Thread Thread Starter Forum Replies Last Post
BEs 5.0.2 inplace upgrade of sql express to sql server 2005 elbutre BES Admin Corner 5 10-27-2010 05:59 AM
Moving BlackBerry Enterprise Server for Exchange to a New Server garycutri BES Admin Corner 0 09-20-2008 12:57 PM
BES upgrade to 4.1.6 Horsebox BES Admin Corner 3 08-05-2008 07:27 PM
Doing a Knife-Edge cutover on BES 4.1 PLumCrazy09 BES Admin Corner 13 03-25-2008 04:16 PM
Help required migrating from an old WinNT4 BES3.6 to Win2003 Server BES4.0 johnny_boy_uk BES Admin Corner 22 01-28-2008 01:44 PM





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