+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
Windows Thread, Backup HELP!!! in Technical; Hi i was just checking my backups and it isnt doing the SIMS SQL database for some reason?!? Thank god ...
  1. #1
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38

    Backup HELP!!!

    Hi i was just checking my backups and it isnt doing the SIMS SQL database for some reason?!? Thank god i take a manual backup everyday!

    Anyways when i go and edit the job and tick the 'SQL2005 SIMS' item in the job properties it gives me an error message. I have tried stopping the SQL service on the server it is backing up from but that wasnt it.

    Any ideas? I have also tried creating a new job and it does the same thing.
    Attached Images Attached Images

  2. #2
    cookie_monster's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    4,205
    Thank Post
    394
    Thanked 278 Times in 239 Posts
    Rep Power
    74
    Some backup software can't backup a live SQL Db do you have an agent for this, It should be backing up the zipped backups in the backups folder though.

    What backup software are you using?
    Last edited by cookie_monster; 10th March 2008 at 12:34 PM.

  3. #3
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    It has the old SIMS SQL selected but it wont let me tick SIMS 2005.

    Using Symantec Backup Exec 10d.

  4. #4
    Jona's Avatar
    Join Date
    May 2007
    Location
    Cranleigh
    Posts
    469
    Thank Post
    14
    Thanked 50 Times in 48 Posts
    Rep Power
    23
    I think the approved of backup method for SQL server is to make a SQL backup job that runs before you main backup and dumps to .bak files or similar which can then be backed up as apposed to trying to backup the .mdf or .ldf files as you probably won't be able to get a handle on these as they are constantly in use.

    Cheers
    Jona

  5. #5
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    @ Jona - How can i do that?

  6. #6

    Join Date
    Mar 2007
    Posts
    1,791
    Thank Post
    82
    Thanked 296 Times in 227 Posts
    Rep Power
    87
    can you backup any other 2005 db's? there is a patch needed for some versions of backupexec.

  7. #7
    cookie_monster's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    4,205
    Thank Post
    394
    Thanked 278 Times in 239 Posts
    Rep Power
    74
    Without an agent i don't think 10d will get a clean backup of the Db so you would normally restore from the zipped .bak files anyway this is the supported SIMS method.

    Have you recently performed a migration and ended up with multiple SQL instances?

  8. #8
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    Havent got any other 2005 sql db's

  9. #9

    Join Date
    Mar 2007
    Posts
    1,791
    Thank Post
    82
    Thanked 296 Times in 227 Posts
    Rep Power
    87

  10. #10
    salan's Avatar
    Join Date
    Nov 2007
    Posts
    384
    Thank Post
    41
    Thanked 42 Times in 28 Posts
    Rep Power
    27
    We issue a 'net stop simssql2005' command before the backup then a 'net start' after the backup. Works for us.
    Alan

  11. #11
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    Quote Originally Posted by cookie_monster View Post
    Without an agent i don't think 10d will get a clean backup of the Db so you would normally restore from the zipped .bak files anyway this is the supported SIMS method.

    Have you recently performed a migration and ended up with multiple SQL instances?
    Did an upgrade a few months ago so there is 2 SQL db's one 2000 and one 2005

    Quote Originally Posted by strawberry View Post
    Doesnt work have just installed it.

    Quote Originally Posted by salan View Post
    We issue a 'net stop simssql2005' command before the backup then a 'net start' after the backup. Works for us.
    Alan
    This is good but i cant add it to the the backup so it would be pointless untill i can get this box ticked.

  12. #12
    cookie_monster's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    4,205
    Thank Post
    394
    Thanked 278 Times in 239 Posts
    Rep Power
    74
    Are you not using Dbattach.exe to run a backup each night then?

  13. #13
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    not that i am aware of as our lea take the sims upgrades and then 'modify' them and send us a link to an automated file and it does it all itself - scary but it works.

  14. #14
    cookie_monster's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    4,205
    Thank Post
    394
    Thanked 278 Times in 239 Posts
    Rep Power
    74
    If it is you'll have a scheduled task that runs a .bat file each night and lots of .zip files in a folder called 'backup' in your SQL instance folder same folder level as the data folder.

  15. #15
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    Fixed!!!

    It was in the document that strawberry linked to, what it was is that you had to run an update on the remote server as well as the server file was found at "c:\program files\veritas\backup execv\nt\agents\rant32\raws.msp" for future information! It was listed in the middle of a paragraph and not made clearly visible they should put it in bold or underline it or something to make it stand out more!!

    Thanks everyone for your help ;-)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. OWA Backup
    By apeo in forum How do you do....it?
    Replies: 7
    Last Post: 4th December 2007, 01:47 PM
  2. Veritas Backup Exec Remote Backup
    By apeo in forum Windows
    Replies: 7
    Last Post: 20th September 2007, 10:16 PM
  3. Backup Tapes Replacement & Backup Schedules
    By robknowles in forum Hardware
    Replies: 2
    Last Post: 18th April 2007, 10:55 PM
  4. Replies: 9
    Last Post: 1st August 2006, 10:25 AM
  5. Backup Script for NT backup and Robocopy
    By ChrisH in forum Scripts
    Replies: 12
    Last Post: 20th October 2005, 01:01 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
  •