cancel
Showing results for 
Search instead for 
Did you mean: 

Backing up SQL Server 2005 Express Edition ???

thekid70
Not applicable
Hello I have Backup Exec 12.5 and today I installed SQL Server 2005 Express Edition for some imaging database. 

I would like to utilize my back up softare and tape system. Can i back up the databases using 12.5 or do I need to purchase the SQL agent to make this happen.

Thanks
3 REPLIES 3

CraigV
Moderator
Moderator
Partner    VIP    Accredited

Abhijit_Soman
Level 6
Partner Accredited
Hi

As far as Microsoft SQL 2005 databae consern for online SQL database backup, SQL agent license is required.

Another solution is to stop SQL services and take cold / offline backup but this will required the down time

Ben_L_
Level 6
Employee
As Abhijit noted, a SQL license is required to backup the SQL databases while they are online.  Another option would be to use SQL to perform a backup to flat file, then use Backup Exec to backup the flat file.