+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, backingup sims backupexec 11d in Technical; Hi i am trying to backup sims using the sql option with a remote agent installed on the sims server ...
  1. #1

    Join Date
    Feb 2007
    Location
    uk
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    backingup sims backupexec 11d

    Hi

    i am trying to backup sims using the sql option with a remote agent installed on the sims server


    but it will not backup the files

    error message is


    Database \master was not found, or could not be accessed.
    Database \model was not found, or could not be accessed.
    Database \msdb was not found, or could not be accessed.
    Database \Northwind was not found, or could not be accessed.
    Database \pubs was not found, or could not be accessed.
    Database \sims was not found, or could not be accessed.


    any ideas

  2. #2

    Join Date
    Apr 2007
    Location
    NW1
    Posts
    38
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: backingup sims backupexec 11d

    check:

    https://forums.symantec.com/syment/b....id=7075#M7075

    looks like sp4 hotfix could solve it if you are on sql 2000

  3. #3

    Join Date
    Feb 2007
    Location
    uk
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: backingup sims backupexec 11d

    thanks for that i dont want to do that at the moment incase sims goes wrong.

    can i back it up using a command line?

  4. #4

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    226
    Thank Post
    7
    Thanked 54 Times in 49 Posts
    Rep Power
    29

    Re: backingup sims backupexec 11d

    Easy to do using command line. Just stop the service first to make sure the database files are not open, then start them again after the copy:

    net stop sqlagent$sims
    net stop mssql$sims
    Copy /y /b "Location of .mdf file here" "Backup location Here"
    Copy /y /b "Location of .ldf file here" "Backup location Here"
    net start mssql$sims
    net start sqlagent$sims

    We run this batch file as a scheduled task every night. Then use BE remote agent to copy the backups to our tape drive. No SQL agent needed.

  5. #5

    Join Date
    Feb 2007
    Location
    uk
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: backingup sims backupexec 11d

    Hi
    thanks for that script will try it tonight
    does that sims database include the finance?

    once again thanks for the help

  6. #6

    Join Date
    Nov 2006
    Location
    Derbyshire
    Posts
    101
    Thank Post
    16
    Thanked 5 Times in 4 Posts
    Blog Entries
    1
    Rep Power
    17

    Re: backingup sims backupexec 11d

    Doesnt resolve the issue, but it may ease your worries (in case you dont know about it) but you can backup SIMS from the System Manager before doing anything you arent sure of

  7. #7

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    226
    Thank Post
    7
    Thanked 54 Times in 49 Posts
    Rep Power
    29

    Re: backingup sims backupexec 11d

    The finance database is two different files and the services are different.
    You can start it and stop it using the net stop and net start command in the same way but the syntax depends on what the database instance is called.

    Ours is:
    net stop SQLANYs_SIMS_SQL_DB_Server

    but the bit after the SQLANYs will vary from system to system depending how it was set up. Look in the Services list on the server and see what name is assigned to the SQL Anywhere service - thats what you need to use.

    Like the main sims database, there are two files to copy, but their location and name may vary. By default, they are SIMS.db and SIMS.log

  8. #8

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,682
    Thank Post
    49
    Thanked 484 Times in 351 Posts
    Rep Power
    144

    Re: backingup sims backupexec 11d

    Now Im neither a Sims or SQL Expert but I have many years experience in this market sector.

    As I have had to rebuild many a failed server, you become a little hardened to the many caveats and gotchas of users data storage methods.

    It is normal practise to use the SQL Manager to perform regular Online backups to the SQL Backups folder.
    These can be selected and backed up at anytime by any backup application without shutting the server or services down.

    There are various backup utilities that exist that have special database aware agents that will allow backup of databases live and these do have a place.

    Offline Backups can be made by scripting the services to stop, backup the whole lot and restart.

    Other methods use Volume Shadow Copy Services to Snapshot the whole volume and archive this in a binary fashion, these include most CDP products such as Acronis, Veritas CDP which also provide effective recovery methods at a cost.

    So here is my spanner in the works so to speak, SQL Databases use tables to store data. These tables in the most part are text based.
    If your application stores binary files such as the kids photos in jpeg formats etc these tables are often skipped by the simpler backup applications due to the fact that that they just don't know how to handle them.
    When you restore a table or database and there is an inconsistency due to binary tables being reported as missing or corrupt your screwed!

    The last time I checked there are very few products claiming to be able to do this, Veritas's NetBackup product was one.
    Being able to handle these types of tables is essential if you want to be able to restore just a few parts of a SQL system so using other 3rd party applications to backup your SIMS server might just be a waste of time and money as these products may never actually deliver a totally restorable version of a corrupt or damaged table anyway!

    With the sudden upsurge in SQL based portals, there is now an urgency for SQL backup systems with truly granular restoration abilities and these are indeed begining to happen, albeit at a price.

    So, IMOHO, using SQL manager to backup the DB several times a day to disk, enabling restoration in full to the last couple of hours would be a dam good idea.
    Use a script to stop all SQL services and perform a full and complete off-line backup at least once a week.

    Pay through the nose if you really must for a backup tool that guarantees that your data can be recovered right down to record level, if such a tool really exists!

    Most people seem to spec thier SIMs servers pretty high and the instances of complete and utter hardware failure are actually quite small, the most common reason for doing a SIMs restore is corruption by updates, user or other means, so the ability to restore an earlier copy quickly with the smallest amount of re-entry needed is the best solution and clearly this can be done using just the native applications!

    IF YOU HAVE 11D and a SQL Agent I would bet you will always end up restoring the previous days backup in full anyway in order to recover, and as this is achieved with native tools why bother!

  9. #9
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    4,002
    Thank Post
    983
    Thanked 477 Times in 398 Posts
    Blog Entries
    12
    Rep Power
    98
    Working here ok with 10d SP4 if that's any help.

  10. #10

    Join Date
    Sep 2007
    Posts
    181
    Thank Post
    4
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    Quote Originally Posted by m25man View Post
    It is normal practise to use the SQL Manager to perform regular Online backups to the SQL Backups folder.
    How do schedule such a backup to take place one per day, for example?

  11. #11
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    34
    Quote Originally Posted by jwood View Post
    How do schedule such a backup to take place one per day, for example?
    The exact route depends on your version of sql server, but generally speaking you need to open the SQL Server management application and set up a maintenance plan.

    Assuming you've migrated to SQL2005 by now, it lives at:

    server\instance > management > maintenance plans - right-click - New maintenance plan

    By default that will back up to the Backups folder as m25man said, so you just need to back up the .bak file(s) in there to tape afterwards.



SHARE:
+ Post New Thread

Similar Threads

  1. Netware & BackupExec
    By RoyG in forum Netware
    Replies: 11
    Last Post: 5th January 2011, 12:20 PM
  2. Post SIMS migration backup with BackupExec
    By ndavies in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 04:13 PM
  3. Backing up MSDE (WMSDE for WSS) database with BackupExec
    By meastaugh1 in forum How do you do....it?
    Replies: 13
    Last Post: 23rd July 2006, 02:56 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
  •