+ Post New Thread
Results 1 to 9 of 9
Enterprise Software Thread, SQL 2012 Backup in Technical; Hi Everyone, I have been looking at the site for a while now and have just got a position as ...
  1. #1

    Join Date
    Sep 2013
    Posts
    74
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    3

    SQL 2012 Backup

    Hi Everyone,

    I have been looking at the site for a while now and have just got a position as the IT Manager at a school so decided to register,
    I am sorry if this is in the wrong area but after having a look at the way everything is set up at the school I am a little concerned
    about the sql server backup.

    The server is currently running 2008 R2 with BE 2010 R3, there is no SQL client installed for BE but the only file that is being skipped
    according to the logs is a USB driver, as I want to make sure the SQL databases are being backed up is there anyway of scheduling a script
    so that it can stop the SQL service, backup the databases to another location on the server then restart the services.

    I do appreciate that you can log into SQL 2012 and backup the databases manually but this is not really a viable solution and I would like to
    script it so that I can then forget about it.

    Any help would be greatly appreciated thanks.

  2. #2

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,066
    Thank Post
    592
    Thanked 1,039 Times in 797 Posts
    Blog Entries
    15
    Rep Power
    469
    Always worth being proactive with backups. Grab something liek BackupAssist with the SQL addon - educational pricing for that is very cheap.

  3. #3

    Join Date
    Dec 2011
    Posts
    404
    Thank Post
    368
    Thanked 45 Times in 33 Posts
    Rep Power
    13
    Might be worth using scheduled maintenance plan for SQL (we did this on some of our SQL servers) the Resulting .bak file could then be backed up with Backup Exec.

    Buys you some time to test an alternative solution till then. (If school has EES agreement, DPM is quite reasonable.

    SQL 2012 Scheduling Auto Backup - CodeProject
    Last edited by MrWu; 14th September 2013 at 09:26 AM.

  4. #4

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,066
    Thank Post
    592
    Thanked 1,039 Times in 797 Posts
    Blog Entries
    15
    Rep Power
    469
    DPM is a pain in the arse though if, unlike Microsoft, you live in the modern era and don't use tape. Any benefit of it being included with your EES agreement is soon wiped out if you want to add in anything like filestreamer.
    BA was something like 150 quid, so very good value for money.

  5. Thanks to synaesthesia from:

    MrWu (14th September 2013)

  6. #5

    Join Date
    Sep 2013
    Posts
    74
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    3
    Quote Originally Posted by MrWu View Post
    Might be worth using scheduled maintenance plan for SQL (we did this on some of our SQL servers) the Resulting .bak file could then be backed up with Backup Exec.

    Buys you some time to test an alternative solution till then. (If school has EES agreement, DPM is quite reasonable.

    SQL 2012 Scheduling Auto Backup - CodeProject
    We dont have an EES at the moment but it is something I am looking into, had 2 quotes in the last 2 days and there coming out well within budget so will be looking at taking that out next week.

    I am not that familiar with DPM is it straight forward to use and will it work with our current backup to RDX cartridge solution ??? I did enquire yesterday about the IDR add-on for BE 2010 but was told it was no longer available and to upgrade to BE 2012 as its allready included, we do have a copy of BE 2012 that came with our last server from Dell but its not that straight forward to use is backup assist any better ???
    Last edited by Marc_Lemar; 14th September 2013 at 11:39 AM.

  7. #6

    Join Date
    Dec 2011
    Posts
    404
    Thank Post
    368
    Thanked 45 Times in 33 Posts
    Rep Power
    13
    Hi

    DPM is very easy to setup, you can run it in a cheap HP microserver with load of SATA disk for example.

    It will backup Exchange, SQL as well as file shares and even VMs, you can take snapshots as regular as 15 minutes

    You can chain DPM servers together so one backs up the other, good for putting a DPM in another building

    Disadvantage:

    Tape back up is a bit if a pain, in this case BE is better in a sense recovery is easier, although DPM is designed towards disk based backup and recovery

    It does occasionally drop DPM agents but I had this few and far between

    It could be that using a scheduled maintenance plan and using BE to backup the .bak file is more than adequate for now, worth looking at BA as well as synaestheia mentioned
    Last edited by MrWu; 14th September 2013 at 12:40 PM.

  8. #7

    Join Date
    Sep 2013
    Posts
    74
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    3
    Thats great thanks everyone gives me something to look at on Monday when I get back to school, currently BE 2010 says its only skipping one file and thats
    a sub driver but if thats the case why do they sell the additional SQL add-on ???

    The plan is to get the .bak files to backup to a shared drive on another server so at least 2 servers back up the data.

  9. #8

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,161
    Thank Post
    403
    Thanked 623 Times in 569 Posts
    Rep Power
    181
    The SQL addon allows you to verify databases, perforn restores etc all though BE. It's not that badly priced either from what I remember. I'd be cautious about whether your current setup is backing up SQL properly. In the selection list do you see SQL databases listed?

  10. #9

    Join Date
    Sep 2013
    Posts
    74
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    3
    Yes they are listed there but that is why I had my doubts and why I want to create a script to make the .bak files at least then if it all fails I have the .bak files to restore, I am currently looking as BE 2012 as it comes with its own form of Intelligent Disaster Recovery.

    A lot of people on here have mentioned Backup Assist but I have not seen it and dont know a great deal about it either, If I can get IDR working I have a spare server and can test the restore process.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Migrated to SQL 2012 - Tons of password resets!
    By adamf in forum MIS Systems
    Replies: 12
    Last Post: 17th February 2014, 06:00 PM
  2. [SIMS] Sending SQL 2012 data to Capita
    By adamf in forum MIS Systems
    Replies: 17
    Last Post: 29th May 2013, 08:54 PM
  3. SQL 2012 express silent/unattended installs
    By Superade in forum MIS Systems
    Replies: 5
    Last Post: 16th May 2013, 11:18 AM
  4. SQL 2012 Backup
    By Homeland in forum Enterprise Software
    Replies: 1
    Last Post: 12th April 2013, 11:14 AM
  5. SQL Server Backup Modes
    By mbyrew in forum Enterprise Software
    Replies: 0
    Last Post: 21st January 2011, 08:27 PM

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
  •