BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 07-07-2011, 09:58 AM   #1
alandry
Thumbs Must Hurt
 
Join Date: Mar 2006
Location: Milford Conn
Model: 9530
OS: 5.0.0.328
Carrier: verizon
Posts: 69
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



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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 04:59 AM
Moving BlackBerry Enterprise Server for Exchange to a New Server garycutri BES Admin Corner 0 09-20-2008 11:57 AM
BES upgrade to 4.1.6 Horsebox BES Admin Corner 3 08-05-2008 06:27 PM
Doing a Knife-Edge cutover on BES 4.1 PLumCrazy09 BES Admin Corner 13 03-25-2008 03: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


061700-3770 Time Delay Relay Solenoid For Kubota Solenoid BX1860 BX1870 F1900 picture

061700-3770 Time Delay Relay Solenoid For Kubota Solenoid BX1860 BX1870 F1900

$45.99



3/4

3/4" Brass Electric Solenoid Valve 110V 120V Volt AC Water Air Gas VITON NC B21

$36.20



SA-3786-12 603350 Fuel Shutoff Solenoid Kubota Compatible 721D2 21HP Grasshopper picture

SA-3786-12 603350 Fuel Shutoff Solenoid Kubota Compatible 721D2 21HP Grasshopper

$29.29



Hydraforce SV10-47B Solenoid Operated Spool Cartridge Valve NEW picture

Hydraforce SV10-47B Solenoid Operated Spool Cartridge Valve NEW

$33.83



Concentric -  1261014 12 Volt DC Power Unit Solenoid Operation Single-Acting picture

Concentric - 1261014 12 Volt DC Power Unit Solenoid Operation Single-Acting

$225.00



3/8

3/8" Inch 4 Way Directional Control Cylinder Electric Solenoid Air Valve 12V DC

$35.99







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