Enterprise Software Thread, Backing up Microsoft SQL in Technical; We are making more use of SQL databases now. ILM has its own SQL database, and now we have just ...
8th February 2012, 02:49 AM #1
Backing up Microsoft SQL
We are making more use of SQL databases now. ILM has its own SQL database, and now we have just gone to Oliver 5.0 this uses its own SQL database as well. Im pretty new to SQL and dont really know much ;p
What is the best way to backup these SQL databases?
We have Backup Exec 2010, is there an SQL component for that (and does it require extra licensing?)
Or is the internal backup from within SQL sufficient? (whats the best way to set this up?)
8th February 2012, 08:05 AM #2
From using older versions of backup exec before,we had to purchase the SQL licences.
We ended up using maintenance plans in SQL to backup up all databases to the hard drive and then use Backup Exec to back the bak files up.
Hope this helps
5th March 2012, 12:10 PM #3
Yes, you will have to purchase SQL agents from Symantec to enable Backup Exec to backup your databases.
For my SQL Server Express databases I run a script that generates a flat file that I then backup. The obvious disadvantage being the time lag between the file being generated and it being backed up.
5th March 2012, 12:12 PM #4
thanks. Ive just ended up going with a full disk backup option backing up the entire server. (shadowprotect server)
5th March 2012, 12:14 PM #5
Have you purchased a SQL agent from Symantec? If not it won't back up your database correctly.
Originally Posted by RabbieBurns
5th March 2012, 12:15 PM #6
Ive just ended up going with a full disk backup option backing up the entire server. Using shadowprotect server. Not Symantec.
5th March 2012, 12:16 PM #7
I run a script using expressmaint.exe to do this and whilst it's not on the same level of transactional backups it is good enough for our purposes.
5th March 2012, 12:16 PM #8
5th March 2012, 12:44 PM #9
depending on your version of SQL it can do its own backup which creates a file in the sql backups folder. Simply back this folder up as normal.
5th March 2012, 12:54 PM #10
Rabbie - have you tried doing a restore of the SQL database from your full disk backup - apologies if you have and I'm teaching you to suck eggs. We ended up going the same way as others have above, nightly incremental DB backups from SQL Server Management Studio with a weekly full backup of each DB. These get picked up by the file backup job that runs 1 hour later each night - we've test restored the backups and confirmed it's all good.
5th March 2012, 01:18 PM #11
Ive brought the backuped disk up in a VM and its fine. Shadowprotect backs up the disk not the files, and lets you restore the entire server not just an application or file.
By glennda in forum Windows
Last Post: 6th August 2010, 01:19 PM
Last Post: 12th October 2009, 01:06 PM
By faza in forum How do you do....it?
Last Post: 10th February 2009, 11:14 AM
Last Post: 8th June 2006, 10:36 PM
Last Post: 23rd May 2006, 12:29 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)