|
Backup the BESMgmt database script |
|
Sunday, 21 September 2008 |
|
In order to backup the BlackBerry Configuration Database on a BlackBerry Enterprise server, you should - Create a folder on the root of the C drive called backup
- Within that folder create a file called DBBackup.BAT
- Edit the file with notepad and add the following text
osql -E -Q "backup database besmgmt to disk='c:\backup\besmgmt.bak'"
Set CURRDATE=%TEMP%\CURRDATE.TMP Set CURRTIME=%TEMP%\CURRTIME.TMP
DATE /T > %CURRDATE% TIME /T > %CURRTIME% Set PARSEARG="eol=; tokens=1,2,3,4* delims=/, " For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=%%l%%k%%j Set PARSEARG="eol=; tokens=1,2,3* delims=:, " For /F %PARSEARG% %%i in (%CURRTIME%) Do Set HHMM=%%i%%j%%k
RENAME c:\backup\besmgmt.bak besmgmt_%YYYYMMDD%%HHMM%.bak
Note: if the Database is not called BESMgmt then you will need to change the name of the database within the first line of the script. - If you want you can then create a Scheduled Tasks within Windows to run the bat file to backup the database.
|