+ Post New Thread
Results 1 to 5 of 5
Windows Thread, Backup Exec 10d and MS SQL 2008 in Technical; Hi all, Bit of a long shot here, but is anyone using Backup Exec 10d (I know, I know - ...
  1. #1
    Duke's Avatar
    Join Date
    May 2009
    Posts
    1,017
    Thank Post
    300
    Thanked 174 Times in 160 Posts
    Rep Power
    58

    Backup Exec 10d and MS SQL 2008

    Hi all,

    Bit of a long shot here, but is anyone using Backup Exec 10d (I know, I know - been trying to get the budget to upgrade for ages) with MS SQL 2008 (on Server 2008 x64)? I've just deployed a new SQL 2008 box and I have the SQL licensing on the BE server, but if I add the server under BE then it just sees the drive shares. I can't remember if I need to install the BE SQL agent on the SQL server first, but I'm hesitant to put such an old agent on a new server in case it breaks something.

    The 'official' answers on the BE forums seem to suggest you need at least 12.5 to get it working but I thought I'd see if anyone had any luck otherwise.

    Many thanks in advance,
    Chris

  2. #2
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,226
    Thank Post
    161
    Thanked 150 Times in 135 Posts
    Rep Power
    104
    Hello,

    I have the same issue... because i'm a bit worried to put the agent on, I created 2 scheduled tasks, 1 to stop the SQL server services and copy the MDF & LDF files to a share on the network, one to re-start the SQL server. Obviously, when you've got a large DB it's going to be a nightmare to do but at the moment this is working for me... I suppose I could just start the backup later (midnight) and schedule to stop the services and backup the program files location as it'd backup the mdf and ldfs.

    With 10d I found even on 2005 it didn't really work properly, since then i've been very scared to rely on it.

    If you find a solution please do let me know

  3. #3
    Duke's Avatar
    Join Date
    May 2009
    Posts
    1,017
    Thank Post
    300
    Thanked 174 Times in 160 Posts
    Rep Power
    58
    That's pretty much what we're doing currently on the existing SQL server, and it does involve our MIS going down for a couple of hours at night while the SQL instance is stopped and the DB files copied. I didn't have enough BE SQL licences to back up the MIS SQL server, so the plan is to consolidate everything to one SQL box and back that up using the proper agent.

    From what I can see everywhere, 10d will not do Server 2008 with SQL 2008, you need BE 12.5 or later. I have a quote for Backup Exec 2010 and it's not really too unreasonable, if you want prices PM me and I'll send you what I've got.

    Chris

  4. #4
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,484
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114
    Why not schedule a maintenance task on with SQL management studio that backs up the database to a file while it's running? This file then ends up on the backup each day with the normal file agent and can be overwritten each time the backup runs (unless it's a small DB and you want more copies).

    No need to start/stop services these days.

  5. Thanks to DMcCoy from:

    Duke (12th April 2010)

  6. #5
    Duke's Avatar
    Join Date
    May 2009
    Posts
    1,017
    Thank Post
    300
    Thanked 174 Times in 160 Posts
    Rep Power
    58
    Oh, there's definitely better ways than what we're currently doing, don't worry I know.

    I know the in-built MS SQL backup is pretty good, and I guess if I can't get BE upgraded then what you've suggested will be the best option. I hopefully will get it sorted out through BE as it just makes it that bit easier to manage and get the data off to tape / D2D.

    Chris

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 6th January 2010, 11:59 AM
  2. Backup Exec 12 problem on Windows 2008
    By TheCrust in forum Windows Server 2008
    Replies: 10
    Last Post: 19th August 2009, 12:16 PM
  3. Replies: 18
    Last Post: 14th February 2008, 09:23 AM
  4. Symantec Backup Exec 10d Price
    By john in forum Educational Software
    Replies: 7
    Last Post: 31st October 2006, 09:42 PM
  5. ...Install MS SQL 2005 and Veritas Backup Exec??
    By LordGrey in forum How do you do....it?
    Replies: 3
    Last Post: 27th September 2006, 05:44 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
  •