Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2009
    Posts
    10

    Unanswered: BAck UP and Recovery ASE 15 windows

    how to perform backup and recovery operation in a proper way using Syabse Ase 15 (windows)? besides dumping our own db, should there be any extra database like master to be backup?

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Start reading
    Adaptive Server Enterprise 15.0
    System Administration Guide: Volume 2
    Chapter 11: Developing a Backup and Recovery Plan
    Scheduling backups of master

  3. #3
    Join Date
    Mar 2009
    Posts
    10

    thnk

    thanks dude, 1 more question, when we do the backup routine, besides backup our own db, should we back up all of these system database also like :

    master
    model
    sybmgmtdb
    sybsystemdb
    sybsystemprocs

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Yes .

  5. #5
    Join Date
    Mar 2009
    Posts
    10
    huhu, another 1, mayb the last 1,

    i can dump the master database, but i cannot restore it back, the error appears like " load database must be used in single mode". but, master database options can not be changed.

    so, some said, in order to use in single mode, must edit parameter line and put "-M". but how? any help?

  6. #6
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    should be lowercase -m in your RUN_srv file
    or
    startserver -f RUN_srv -m
    will start the setver in single user mode, then you can load master

  7. #7
    Join Date
    Mar 2009
    Posts
    10
    RUN_srv is stand for ?

    million thanks

  8. #8
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    The run server file is unix related
    Follow this link for info including startup for windows

  9. #9
    Join Date
    Mar 2009
    Posts
    10
    ok, done, thank u, now i am trying to explore the adaptive server logins, database user and managing user permission. but i got 1 problem, i do not know how to grant all object permission to the new user ( not the dbowner).so, should i change the dbowner in order to grant all the permission?

  10. #10
    Join Date
    Mar 2009
    Location
    Sydney, Australia
    Posts
    258
    No leave the dbowner as is, that should be a special "owner", often sa or some non-human.

    You need to learn basic SQL, which is the language used to administer and manage the server and the dbs, plus the Sybase-specific extensions. The command is grant select on table to user.

    But that's just answering your simple question. You need to think about and set up a security model, so that you are not doing simple low-level grants all the time. The standard is:
    - do not use Groups, they are deprecated
    - no grants directly to Users
    - all grants to Roles, and then grant Roles to Users
    - all transactions in stored procs
    - no grant insert/update/delete to Users or Roles
    - grant exec on selected procs to Roles (which means all insert/update/deletes are forced to be transactional and users cannot directly update the tables non-transactionally, eg. via MS Excel)
    - grant select, references to Roles
    --- for a corp that has tight internal security, you can grant select, references to public
    - no aliases
    ANything less that that and you will have (a) more manual labour administering the grant/revokes and (b) security holes in your database.
    Regards
    Derek Asirvadem (Formerly DerekA)
    Information Architect / Senior Sybase DBA
    Copyright 2009 Software Gems Pty Ltd

    I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

    http://www.softwaregems.com.au

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •