1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TDP for SQL: Backups changing DB recovery mode from "normal" to "simple"?

Discussion in 'TDP/Application Layer Backup' started by c.j.hund, Sep 11, 2006.

  1. c.j.hund

    c.j.hund ADSM.ORG Member

    Joined:
    Jun 22, 2005
    Messages:
    222
    Likes Received:
    0
    Occupation:
    Tivoli Admin
    Hi all,



    Has anyone every bumped into a situation where the SQL TDP would change a DB's recovery mode from "normal" to "simple". We see this happening on one of ten databases I back up using the SQL TDP, and managment believes that TSM could be the culprit. I think that's hogwash, but maybe someone else has seen this before? Again, it only happens on one DB, and it happens intermittently.



    Any thoughts would be greatly appreciated.



    Sincere thanks,

    C.J.
     
  2.  
  3. Jeroen

    Jeroen ADSM.ORG Senior Member

    Joined:
    Oct 2, 2002
    Messages:
    359
    Likes Received:
    13
    Occupation:
    AIX + storage administrator
    Location:
    netherlands
    I have managed a lot of TDP for SQL systems, but I have never seen this kind of behaviour.

    I even doubt that TSM will be able to change the recovery mode of the database.
     

Share This Page