11-01-2011 02:35 PM
If I am running BE 2010 and have a small SQL Express database in 2008 R2, would I actually need the SQL agent to back this up database up? Wouldn't it be part of the Shadow Copy snapshot?
11-01-2011 05:34 PM
Hi
Yes to backup the SQL database with backupexec you need SQL agent
But then if you donot want to backup you can backup SQL database through SQL studio & then backup that using backupexec
Thank You
11-03-2011 02:04 AM
Shadow copy snapshot will not contain SQL Database information and hence once the SQL Agent license is installed, you can select the SQL Express instance which will include all SQL Database and back it up using Backup Exec.
However, if you have backed up SQL database using SQL management studio, you can simply backup the .bak files of your SQL database using Backup Exec (No need for SQL agent license in this case). This means, you can simply restore these .bak database files during any SQL database recovery. It will be something like an Offline SQL database backup.