Homeland Posted April 12, 2013 Posted April 12, 2013 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.
localzuk Posted April 12, 2013 Posted April 12, 2013 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now