SQL 2012 Backup
We currently have a 2008 R2 member server that acts as an SQL Server running full blown SQL2012, at the moment it only runs the new finance system but will soon also be running SIMS, Sophos etc. as and when I can get the databases moved over.
Is there anyway of automating the process of backing up the databases within SQL2012 so that they are copied to an area of the server ??? I will be installing Backup Exec 2010 on the server when I get back to school next week but know there were issues in the past with BE not being able to backup SQL databases.
To backup SQL, you either need to run scripts that do the job for you, or use a 'dedicated' SQL backup tool. BackupExec has an SQL module which does the backing up, as does BackupAssist amongst others.
I'd recommend BackupAssist - its cheap but powerful. We have transactional backups in place, so we can roll back part of a day if we want to.