+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Post SIMS migration backup with BackupExec in Technical; Hi After SIMS migration to SQL Express, we need to alter the back up job to exclude the old SQL ...
  1. #1

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Post SIMS migration backup with BackupExec

    Hi

    After SIMS migration to SQL Express, we need to alter the back up job to exclude the old SQL instance and include the new SQL2005 instance of the SIMS database for the backups, in backup exec.

    I've tried editing the job and selecting the SIMS2005 SQL instance but it won't let me saying "couldn't connect to the database"

    Anybody done this successfully. any tips?!

    Nick

  2. #2
    Disease's Avatar
    Join Date
    Jan 2006
    Posts
    1,059
    Thank Post
    112
    Thanked 63 Times in 44 Posts
    Rep Power
    54

    Re: Post SIMS migration backup with BackupExec

    You need to upgrade to BUE 11d as vrs 10 does not support SQL 2005

  3. #3
    Vegas's Avatar
    Join Date
    Jul 2005
    Location
    Gloucestershire
    Posts
    371
    Thank Post
    19
    Thanked 38 Times in 31 Posts
    Rep Power
    29

    Re: Post SIMS migration backup with BackupExec

    What version of Backup Exec do you have?
    Version 9.1 isn't compatible and version 10 needs a plugin.

  4. #4
    Vegas's Avatar
    Join Date
    Jul 2005
    Location
    Gloucestershire
    Posts
    371
    Thank Post
    19
    Thanked 38 Times in 31 Posts
    Rep Power
    29

    Re: Post SIMS migration backup with BackupExec


  5. #5
    Disease's Avatar
    Join Date
    Jan 2006
    Posts
    1,059
    Thank Post
    112
    Thanked 63 Times in 44 Posts
    Rep Power
    54

    Re: Post SIMS migration backup with BackupExec

    Cool, though I needed an excuse to update my BUE anyway, and 11d has lots of sexy new features.

  6. #6

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: Post SIMS migration backup with BackupExec

    We're using 10d...11d it is then.

    Nick

  7. #7
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,386
    Thank Post
    10
    Thanked 483 Times in 423 Posts
    Rep Power
    110

    Re: Post SIMS migration backup with BackupExec

    10d does support backing up sql 2005 with the hotfix, it doesn't support using an sql 2005 instance for its own database.

  8. #8

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: Post SIMS migration backup with BackupExec

    Applied the patch and it's now let me select SIMS2005...just hope it backs up. been getting these errors

    Event ID: 57860 "An error occurred while attempting to log in to the following server... SQL error number: "0011"" is seen when backing up a server with SQL installed.

    ..maybe the patch might fix this....

  9. #9

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: Post SIMS migration backup with BackupExec

    indeed it did...marvelous!

  10. #10

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,607
    Thank Post
    49
    Thanked 444 Times in 330 Posts
    Rep Power
    136

    Re: Post SIMS migration backup with BackupExec

    Has anybody had a problem with Synetrix (LGFL) Online Backup since the upgrade to SQL 2005?

    I have one thats failed to backup and according to the log it tells you that it's using the wrong version of DBAttach? Reqs Ver1.2 or above and the version in 2005 is 1.7?

    So the LEA's SIMS team did a cracking job, the server has Veritas 9.1 with SQL2000 agent so that's buggered, the Synetrix Online Backup (Now also Screwed) and I can't find a SQL Manager backup in the backup folder since the upgrade date either.

    The school now has no functional Sims Backup at all!

  11. #11

    Join Date
    Sep 2007
    Posts
    181
    Thank Post
    4
    Thanked 2 Times in 2 Posts
    Rep Power
    14

    Re: Post SIMS migration backup with BackupExec

    After upgrading from Backup Exec 9 to 11D, I've found that I can no longer restore from backup sets created with the previous version.

    Is this by design or is there a way around it?

  12. #12
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80

    Re: Post SIMS migration backup with BackupExec

    You can restore the backups using the windows backup utility I thought.

    They are the same format.

    There are also lots of BKF recovery tools available if its corrupted in some way.

SHARE:
+ Post New Thread

Similar Threads

  1. backingup sims backupexec 11d
    By skyline21 in forum MIS Systems
    Replies: 10
    Last Post: 16th January 2008, 05:44 PM
  2. SIMs backup script after SQL 2005 migration failing...
    By mullet_man in forum MIS Systems
    Replies: 13
    Last Post: 23rd November 2007, 06:03 PM
  3. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 12:00 PM
  4. SIMS migration - help needed!
    By ndavies in forum MIS Systems
    Replies: 15
    Last Post: 9th October 2007, 02:21 PM
  5. Scripts not functioning post migration
    By mark in forum Wireless Networks
    Replies: 1
    Last Post: 21st September 2005, 11:13 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
  •