Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2013
    Posts
    2

    Unanswered: where we use truncate_only and no_log and why?

    Hi

    I have been installed Sybase ASE 15.5 server but when i build the server i am getting error, please assist with below error.


    [sybase@localhost sample_resource_files]$ srvbuildres -r ASE3.rs
    Building Adaptive Server 'HEADBOARD':
    Writing entry into directory services...
    Directory services entry complete.
    Building master device...
    Task failed
    /home/sybase/ASE_15/ASE-15_0/bin/dataserver: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
    Server 'HEADBOARD' was not created.



    Thanks
    Sajid
    Last edited by msajid11; 01-30-13 at 13:53. Reason: Changed question

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Which database software are you asking about?

    If you mention which database(s) about which you have questions, our kind moderator might just relocate your topic.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    truncate_only and no_log are deprecated features of Microsoft SQL Server. They were commonly used by experts doing recovery operations until the release of SQL 2005, but haven't been supported for quite some time.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Jan 2013
    Posts
    2
    hi Team,

    If logsegment is full during dump and load database in sybase, then what kind of action should be perform in production suppot.

    Thanks
    Sajid

  5. #5
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Please post this in the SQL Server section. This is not a "general" database question.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Posting Permissions

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