Link to home
Start Free TrialLog in
Avatar of Bransby-IT
Bransby-IT

asked on

Blackberry SQL Move

Microsoft Windows Server 2003 R2 SP2
Blackberry Enterprise Server Express for Microsoft Exchange
BlackBerry Version 5.0.2 (Bundle 14)

Looking to move my SQL Database from my old SQL server to my new SQL.

Any help be great.
ASKER CERTIFIED SOLUTION
Avatar of setasoujiro
setasoujiro
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bransby-IT
Bransby-IT

ASKER

What does the following do?

Microsoft SQL Server Desktop Engine (MSDE)

1. From a command prompt, type osql -E and press Enter.

Note: If logging in to a named instance of the Microsoft SQL Server, use the following command syntax to log in: osql -E -S <SQL_Server_name>\<instance_name>

2. Type the following commands in the specified order:

  1> backup database <BlackBerry_Configuration_Database_name> to disk = C:\<BlackBerry_Configuration_Database_name>.bak
  2> go
  1> quit

3. Close the command prompt.