+ Post New Thread
Results 1 to 11 of 11
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 ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,527
    Thank Post
    1,339
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    199

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

    Cheers

  2. #2

    Join Date
    Dec 2011
    Posts
    404
    Thank Post
    368
    Thanked 45 Times in 33 Posts
    Rep Power
    13
    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

  3. #3

    Join Date
    Mar 2012
    Location
    Devon
    Posts
    233
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    12
    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.

  4. #4

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,527
    Thank Post
    1,339
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    199
    thanks. Ive just ended up going with a full disk backup option backing up the entire server. (shadowprotect server)

  5. #5

    Join Date
    Mar 2012
    Location
    Devon
    Posts
    233
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    12
    Quote Originally Posted by RabbieBurns View Post
    thanks. Ive just ended up going with a full disk backup option backing up the entire server. (shadowprotect server)
    Have you purchased a SQL agent from Symantec? If not it won't back up your database correctly.

  6. #6

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,527
    Thank Post
    1,339
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    199
    Ive just ended up going with a full disk backup option backing up the entire server. Using shadowprotect server. Not Symantec.

  7. #7

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,657
    Thank Post
    657
    Thanked 1,624 Times in 1,453 Posts
    Rep Power
    422
    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.

    Ben

  8. #8

    Join Date
    Mar 2012
    Location
    Devon
    Posts
    233
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    12
    Ah, sorry. My bad!

  9. #9

    Join Date
    Apr 2010
    Posts
    2,047
    Thank Post
    83
    Thanked 188 Times in 155 Posts
    Rep Power
    84
    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.

  10. #10
    Dickens's Avatar
    Join Date
    Nov 2009
    Posts
    17
    Thank Post
    2
    Thanked 2 Times in 1 Post
    Rep Power
    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.

  11. #11

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,527
    Thank Post
    1,339
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    199
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Backing up SQL 2008
    By glennda in forum Windows
    Replies: 5
    Last Post: 6th August 2010, 12:19 PM
  2. Replies: 1
    Last Post: 12th October 2009, 12:06 PM
  3. Backing up Microsoft Exchange 2007
    By faza in forum How do you do....it?
    Replies: 2
    Last Post: 10th February 2009, 10:14 AM
  4. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM
  5. Mac software for backing up DVDs
    By dagza in forum Mac
    Replies: 14
    Last Post: 23rd May 2006, 11:29 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •