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


New Factory Sealed AB 1747-L532 SER E SLC 500 5/03 CPU Processor Unit 1747L532 picture

New Factory Sealed AB 1747-L532 SER E SLC 500 5/03 CPU Processor Unit 1747L532

$320.76



NEW SEALED AB 1747-L541 /C SLC 500 SLC 5/04 CPU PROCESSOR UNIT MODULE US picture

NEW SEALED AB 1747-L541 /C SLC 500 SLC 5/04 CPU PROCESSOR UNIT MODULE US

$304.07



FANUC A860-2000-T301 PULSECODER picture

FANUC A860-2000-T301 PULSECODER

$325.00



New Factory Sealed AB 1747-L541 SER C SLC 500 CPU Processor Unit 1747L541 picture

New Factory Sealed AB 1747-L541 SER C SLC 500 CPU Processor Unit 1747L541

$363.50



1000W Stainless Steel Welding Bead Processor,Brush Type Weld Cleaning Machine picture

1000W Stainless Steel Welding Bead Processor,Brush Type Weld Cleaning Machine

$199.27



Brand New In Box Omron C200H-CPU21-E PLC picture

Brand New In Box Omron C200H-CPU21-E PLC

$371.00







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