06-17-2009, 08:46 PM
Join Date: Jun 2009
Post Thanks: 0
Thanked 0 Times in 0 Posts
| | BES SQL Server Replacement and Upgrade Process
Please Login to Remove!
Currently, we run BlackBerry Manager version 184.108.40.206 on a Windows Server 2003 machine - which is connected to a separate SQL Server 2000 machine.
It is our intention to replace the SQL Server 2000 machine with a new Server running SQL Server 2005.
We will not be performing an upgrade to SQL Server 2005 on the existing Server - so I would assume this process would involve physically moving the database to the new Server, upgrading it to SQL Server 2005 and then pointing the client application to the upgraded database.
Can anyone please advise:
(i) What process we would follow to move the database from the old SQL Server (MSSQL2000) to the new one (MSSQL2005), and upgrade the database? Do you have documented instructions which details the process we must follow?
(ii) As we are deploying two replacement SQL Servers, we are also considering what options we would have available for Disaster Recovery.
(iii) And KB articles that may document this process and/or any known possible errors.
Any advice is much appreciated. Thank you!