Results 1 to 5 of 5

Thread: transaction backup log is miss?

  1. 09-09-2005, 12:56 AM #1
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421

    transaction backup log is miss?

    Hi all
    I have group of DB Maintenance planes. two of them i have transaction backup every day. but every morning I chack my backup place, not Log back up , but all the data backup . like bat. work fine.
    what is wrong?
    Thank you!
    ________
    Contents insurance forums
    Last edited by sql; 03-06-2011 at 01:51 AM.
    Reply With Quote Reply With Quote
  2. 09-09-2005, 08:16 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Your database may not be in FULL recovery mode. Check the database properties.
    Reply With Quote Reply With Quote
  3. 09-09-2005, 08:50 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    And double check which directory you put log backup files in.
    Reply With Quote Reply With Quote
  4. 09-11-2005, 08:22 PM #4
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421
    Hi all,
    Thank you for the replies. Yes , the database recovery mode become simple, before my setting is full. and some mistake happen. I would check my backup diretion tomorrow.
    Thank you
    ________
    LINCOLN Y-BLOCK V8 ENGINE PICTURE
    Last edited by sql; 03-06-2011 at 01:51 AM.
    Reply With Quote Reply With Quote
  5. 09-12-2005, 11:14 AM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You should either change db recovery model backup to full or create separate plan for the db.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules