Help

Start a discussion
UNSOLVED

Umraan

updated

18 years ago

U

Umraan

96 Posts

0

1519

March 4th, 2009 23:00

level 1 backup always doing full backups

Hi Guys,

I've got this problem with 1 of my clients.
It is always doing full backups regardless of the shcedule or the level.
I'm running Networker 7.4.3 on windows server and this is a MSSQL DB backup.
does any one have a resolution for this?
Please help!

Regards,
Umraan
  • A

    amediratta

    2 Intern

    •

    2014 Posts

    563

    0

    Posted March 5th, 2009 04:00

    You need to enable transaction logging in SQL else it allways take full backup for databases.
  • U

    Umraan

    96 Posts

    563

    0

    Posted March 6th, 2009 02:00

    Hi Thanks for your reply,

    we do not do log backups on this specific server because we have a log shipping server in place for this.
    therefore our DBA writes the logs to the log shipping server.

    Is there any other way to fix this.

    Thanks
    Umraan
  • A

    antoineschokker

    1 Rookie

    •

    70 Posts

    563

    0

    Posted March 6th, 2009 03:00

    Perhaps you checked this already, but just to be sure:

    In the Group-definition, Advanced-Tab is the option LEVEL in the section CLIENT OVERRIDES empty?

    kind regards

    Message was edited by:
    Antoine Schokker
  • B

    ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    563

    0

    Posted March 6th, 2009 13:00

    Level of SQL module depends on SQL recovery model if I remember correctly. Would need to checks docs now, but perhaps you could check what is the model of your SQL db. Also, check the logs -. there might be message saying why full is used instead.
  • U

    Umraan

    96 Posts

    563

    0

    Posted March 9th, 2009 01:00

    yes it's empty....running with the schedule
  • S

    satishs

    50 Posts

    563

    0

    Posted March 9th, 2009 07:00

    yes it's empty....running with the schedule


    Has this backup been like this from beginning or did this start after some change made? What is the schedule you currently use?
  • U

    Umraan

    96 Posts

    563

    0

    Posted March 11th, 2009 01:00

    im not sure how long this backup has been doing this, I have taken over from another administrator...the curent schedule is Monday, Wednesday and Friday Full, the rest of the days will be differential.

    Thanks for you assistance!!
    much appreciated..

    Umraan
  • U

    Umraan

    96 Posts

    563

    0

    Posted March 11th, 2009 01:00

    you could be right!!I
    I only have this problem with 2 of my clients, and both these clienst do not have transaction logs enabled.
    Logs get written manually by the DBA
  • S

    satishs

    50 Posts

    563

    0

    Posted March 11th, 2009 05:00

    im not sure how long this backup has been doing this,
    I have taken over from another administrator...the
    curent schedule is Monday, Wednesday and Friday Full,
    the rest of the days will be differential.

    Thanks for you assistance!!
    much appreciated..

    Umraan

    ----------------

    See if this document # esg51446 applies to your situation?
  • U

    Umraan

    96 Posts

    61

    0

    Posted August 23rd, 2011 02:00

    SQL backup will always be full because log shipping is in place.

    third party software(SQL server) writing the logs, therefore NetWorker does not recognise the last backup and peforms a full.

Dell Support Resources

Latest Solutions

View More