|
A client has Microsoft Small Business Server 2003, which is running Blackberry Professional Software (a limited user version of Blackberry Enterprise Server).
They use Symantec Backup Exec 10d for their backups.
The problem:
Backup Exec would fail with the error:
"V-79-57344-33938 - An error occurred on a query to database BESMgmt.
The item SERVERNAME\BLACKBERRY\BESMgmt in use - skipped.
Final error: 0xe0008492 - Database Query Failure. See the job log for details."
Root cause:
I spent a couple of hours digging in to this - investigating the usual issues of account access and permissions.
However, it turns out there's a bug in the SQL tool used by Blackberry to create the database - it puts an extra backslash in the table's location.
Troubleshooting:
If you suspect this may be your problem you activate Debug Logging in Backup Exec (see http://seer.entsupport.symantec.com/docs/254212.htm)
In the SERVER-beremote.log you will see:
[9452] 02/16/10 12:53:21 ***************************************************************
[9452] 02/16/10 12:53:21 ** **
[9452] 02/16/10 12:53:21 ** SQL Agent Database Path Error **
[9452] 02/16/10 12:53:21 ** **
[9452] 02/16/10 12:53:21 ** The database contains a path with extra backslashes. **
[9452] 02/16/10 12:53:21 ** The database needs to be detached and then attached **
[9452] 02/16/10 12:53:21 ** again using a corrected path. See support website. **
[9452] 02/16/10 12:53:21 ** **
[9452] 02/16/10 12:53:21 ***************************************************************
How we fixed this:
CAUTION:
- These are the steps we carried out to resolve the problem on this particular system.
- This information is given here for reference purposes only.
- The instructions are written for other IT professionals with server access, not lay people!
- Obviously, your SERVERNAME and paths may be different.
Open a command prompt.
CD to C:, then CD "C:\Program Files\Microsoft SQL Server\MSSQL$BLACKBERRY\Binn"
run osql -S SERVERNAME\BLACKBERRY -E
1> exec sp_helpdb BESMgmt
2> go
The tables show as:
BESMgmt_data C:\Program Files\Microsoft SQL Server\MSSQL$BLACKBERRY\Data\\BESMGMT.mdf
BESMgmt_log C:\Program Files\Microsoft SQL Server\MSSQL$BLACKBERRY\Data\\BESMGMT.ldf
IF YOU ARE SHOWING TWO BACKSLASHES, THAT'S THE PROBLEM. HERE'S HOW TO FIX IT:
1. In Windows, Run services.msc and STOP all the "Blackberry XXX" services.
2. Back in the OSQL command box, type:
> sp_detach_db @dbname = BESMgmt (yes, we did it without quotes)
> go
> exec sp_attach_db @dbname = "BESMgmt", @filename1 = "C:\Program Files\Microsoft SQL Server\MSSQL$BLACKBERRY\Data\BESMgmt.mdf", @filename2 = "C:\Program Files\Microsoft SQL Server\MSSQL$BLACKBERRY\Data\BESMgmt.ldf"
> go
> exit
3. Restart all the Blackberry services.
And that was it! A test backup of the Blackberry database then worked smoothly. |
Reference Section 