cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

SQL Express 2008 R2 Backup

TBone_1985
Level 4

‎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?

0 Kudos
2 REPLIES 2

newsolutionBE
Level 6

‎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

0 Kudos

DevG
Level 4
Employee Accredited Certified

‎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.

0 Kudos