Start a Conversation
UNSOLVED

toleolu

updated

18 years ago

T

toleolu

13 Posts

0

559

January 7th, 2009 12:00

SQL Backup Suggestions

We have a Datawarehouse application that runs on SQL 2000 currently. (We are upgrading to 2008). The DB is right at 400GB. We are doing a full backup on Friday but the incrementals during the rest of the week. Problem is the incrementals are pretty much the same size as the full backups. Just curious if anyone might have any suggestions or recomendations.

Thanks
  • S

    salvoemc

    45 Posts

    195

    0

    Posted January 7th, 2009 13:00

    Uhmm check in SQL about rotational logging. If enable this option probably all logs in SQL are the same every day but with new dates, then when try to backup an incremental backup Networker recognize logs are changed then run a full backup.
  • K

    Kirhner

    23 Posts

    195

    0

    Posted January 12th, 2009 16:00

    Maybe logshipping is configured on SQL server, that is not supported. Like Salvor said, if someone job working with SQL transaction log it always generates full backup instead incremental in Networker.
  • A

    amediratta

    2 Intern

    •

    2014 Posts

    195

    0

    Posted January 12th, 2009 19:00

    Do you actually have the logging system enabled? If not, it will take Full only. If logging is enabled, then as suggested, a change in date for the log file will be considered as a candidate for a FULL backup only.

Dell Support Resources

Latest Solutions

View More