BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-22-2007, 09:57 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2006
Location: Blackpool
Model: 8800
Carrier: O2
Posts: 19
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Backing up MSDE Database

Please Login to Remove!

Me again!!! Yes I know am a pain!!

Tomorrow night is out Upgrade and just looking on the best way to backup our database on the BES.

I can see that the person previously to me has been able to do this as can see some old .BESMgmt.bak files.

But how the hell do I do it?
Offline  
Old 08-22-2007, 09:59 AM   #2 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 235 Times in 218 Posts
Default

Quote:
Originally Posted by neilgmt View Post
Me again!!! Yes I know am a pain!!

Tomorrow night is out Upgrade and just looking on the best way to backup our database on the BES.

I can see that the person previously to me has been able to do this as can see some old .BESMgmt.bak files.

But how the hell do I do it?
I use MSDE admin.
MSDE Admin

Well worth the $20 US in my opinion.

You don't need third-party software if you're comfortable entering some SQL statements at a sql command prompt.
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 08-22-2007, 10:05 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2006
Location: Blackpool
Model: 8800
Carrier: O2
Posts: 19
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I just thought I could possibly do it from a command prompt
Offline  
Old 08-22-2007, 10:06 AM   #4 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

osql -E -Q " backup database <BlackBerry_Configuration_Database_name> to disk = 'C:\BESMgmt.bak' "

from the command prompt on the BES

or DbaMgr2k is a freebie written by an MS MVP.
Offline  
Old 08-22-2007, 10:21 AM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2006
Location: Blackpool
Model: 8800
Carrier: O2
Posts: 19
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Absolute gent you are hdawg!!

That with or without the quotation marks?
Offline  
Old 08-22-2007, 10:22 AM   #6 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

with the quotation marks!
Offline  
Old 08-22-2007, 10:25 AM   #7 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

In case you cared ...

English translation:

osql - actual command
-E - use windows authentication
-Q execute the following query
" backup database <BlackBerry_Configuration_Database_name> to disk = 'C:\BESMgmt.bak' "

osql is mighty nice as long as you treat it with the same respect you treat rm -rf / or del /y/q/s C:\
Offline  
Old 08-22-2007, 10:34 AM   #8 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2006
Location: Blackpool
Model: 8800
Carrier: O2
Posts: 19
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
In case you cared ...

English translation:

osql - actual command
-E - use windows authentication
-Q execute the following query
" backup database <BlackBerry_Configuration_Database_name> to disk = 'C:\BESMgmt.bak' "

osql is mighty nice as long as you treat it with the same respect you treat rm -rf / or del /y/q/s C:\

Once again mate I thank and salute you for your knowledge and assistance
Offline  
Old 08-24-2007, 05:45 AM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2006
Location: Blackpool
Model: 8800
Carrier: O2
Posts: 19
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well all went incredibly smoothly except for having to remove msde 7 and install msde2000.

Only problem I have now is some users Blackberries need reactivating.
Offline  




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