BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 10-05-2010, 03:36 AM   #1 (permalink)
New Member
 
Join Date: Apr 2008
Model: 8820
PIN: N/A
Carrier: Orange UK
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES 5.0.2 backup SQL Express Database?

Please Login to Remove!

Im running BES 5.0.2 for Exchange,

I have 130 Users, and running a SQL Express DB. however my Symantec Backup Exec cannot read the SQL Express DAtabase for some reason, as there isnt a prompt for the databse username and password.

I'm now DB expert but is there a SA login on the SQL express Database and can i enable it and set a password on it and give me some privileges for it to be backed up
Offline  
Old 10-05-2010, 05:19 AM   #2 (permalink)
Thumbs Must Hurt
 
elbutre's Avatar
 
Join Date: Oct 2006
Location: London
Model: 9700
Carrier: vodafone
Posts: 75
Post Thanks: 2
Thanked 2 Times in 2 Posts
Default

i odn't know if backup exec has a plugin for sql express databases or maybe it only works for proper sql database (my backup software only recognises proper sql and not sql express)
i have configured a manual backup on my sql express server using this link How to Automate SQL Server Express Backups - Tip of the Week -

i basically run separate scripts for each database on the sql express server and then backup the server (including these sql backup files) and once per week i delete the sql backups again using a script.

not sure if this is the answer you are looking for but it works for me
Offline  
Old 10-06-2010, 08:13 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Feb 2008
Location: Buenos aires, Argentina
Model: 8520
PIN: N/A
Carrier: Claro
Posts: 75
Post Thanks: 0
Thanked 4 Times in 4 Posts
Default

did you try with windows authentication, using besadmin ?

are you shure that is no login :

user:sa
pass:<blank>

i thougth that is the default value

regards
__________________
Martin

Blackberry Instructor
Offline  




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