Results 1 to 5 of 5

Hi, We use BES (blackberry professional software) on a MS SBS 2003 Premium and we ... Server Admins forum

  1. #1
    guidobras's Avatar
    guidobras no está en línea Stack level 1
    Join Date
    Aug 2008
    Posts
    3

    Error backing up BESMgmt DB

    Advertisement



    Hi,
    We use BES (blackberry professional software) on a MS SBS 2003 Premium and we back-up the whole system with Symantec backup Exec 12.

    Since the day we installed BES we have this backup error:
    ----
    The job failed with the following error: The path for this database is invalid because it contains extra backslash characters. You must remove the extra backslash characters before the database can be backed up.
    ----

    I read this veritas support document
    seer.entsupport.symantec.com/docs/294324.htm

    and I checked in MS SQL Server management studio (databases/BESmgmt/Properties/Files) but the file names don't have double backslashes:
    path = F:\BES\MSSQL\DATA File = BESmgmt.mdf
    path = F:\BES\MSSQL\DATA File = BESmgmt.ldf

    I'm stuck with the problem ,any help would be greatly appreciated...
    Thanks in advance

    Guido

  2. #2
    knottyrope's Avatar
    knottyrope no está en línea Stack Professional
    Join Date
    Aug 2007
    PIN/ID
    ask
    Posts
    124
    If using SQL and NOT MSDE or express you can run a sheduled backup to a file and have Veritas back the file up. I used to run a script for express everynight.

    You might need a SQL license for Veristas. I had to buy one for my SQL 2005 server.
    Obi-Wan Kenobi says "Use the search Luke", and Yoda says "RTFM, you should"
    Torch 9800 on BES 4.1.7 MR3, SQL 2005, Exch 03 with 250 hopeless users

    http://twitter.com/#!/knottyrope

  3. #3
    guidobras's Avatar
    guidobras no está en línea Stack level 1
    Join Date
    Aug 2008
    Posts
    3
    Hi knottyrope,
    thanks for your reply!

    I have SQL 2005 installed (included in SBS 2003 R2 premium) and althought I am an absolute beginner with sqlserver, I suppose BESmgmt db is on it because I can see BESmgmt in MS SQL Server management studio.

    Being a newbie I'd prefer to find a solution to the problem I have rather than script a backup into SQL 2005 management studio, which I'm not comfortable with.

    We have a license of Backup Exec that includes the license for SQL server.

    thank you
    Guido

  4. #4
    knottyrope's Avatar
    knottyrope no está en línea Stack Professional
    Join Date
    Aug 2007
    PIN/ID
    ask
    Posts
    124
    OK so when you backup the SQL part do not back up the those two listed files.
    You have to backup the database not the database files.

    Look at the server in BE under selections and it should show Microsoft SQL Server "the instance name"

    In there select the database. and BE will do the job.
    If it is not there then you might have not installed the SQL license, which is another key to add in.
    Obi-Wan Kenobi says "Use the search Luke", and Yoda says "RTFM, you should"
    Torch 9800 on BES 4.1.7 MR3, SQL 2005, Exch 03 with 250 hopeless users

    http://twitter.com/#!/knottyrope

  5. #5
    guidobras's Avatar
    guidobras no está en línea Stack level 1
    Join Date
    Aug 2008
    Posts
    3
    Solved!
    I used the "report" icon in MS SQL Server management studio and in the generated report I saw that the real path was:
    path = F:\BES\MSSQL\DATA\\BESmgmt.mdf
    path = F:\BES\MSSQL\DATA\\BESmgmt.ldf

    then i detached the db, created a new folder for th db files, copiet the db files to the new folder and reattached the db from the new folder.
    Used this MS KB article for doing so:
    support.microsoft.com/?scid=kb%3Ben-us%3B224071&x=12&y=5

    Ciao
    Guido

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •