Skip to Content
author's profile photo Former Member
Former Member

SBO Back Up

Dear Experts,

I have enabled SBO Back up for the DB. Daily basis transactions are entered and logically DB size would increase. But backup size is decreasing one day, another day the size in increasing.

Why is this issue coming. If i schedule this through back up maintenance task of SQL server also, the same thing is happening.

What might be the issue or is it correct.

Pl help

Regards

Sundaram

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2010 at 11:33 PM

    Dear Sundaram,

    How much differences is when the backup size is decreasing? Give an example.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Pl see below the drastic difference in Back Up, am taking the back up through SBO Backup from SAP B1 Service Manager.

      MIPLSAP2007082810000003.zip - 940917.KB - 28th Aug -2010

      MIPLSAP2007090310000014.zip - 858670.KB - 03rd Sep -2010

      MIPLSAP2007090410000004.zip - 863679.KB - 04th Sep -2010

      MIPLSAP2007090510000004.zip - 549287.KB - 05th Sep-2010

      But i have checked randomly the documents and verified TB. Everything is tallying,

      Pl confirm whether it is a problem or what ?

      Have you checked if the auto shrink of database log file is activated ? Check it in your db properties --> options --> auto shrink.

      check if your recovery model is simple or not.

      JimM

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2010 at 02:13 AM

    Hi Sundaram,

    I believe it is from your set up. Are u doing a differential backup ? in that case it is obvious you will be seeing this kind of difference ..

    This will be a issue if you are doing full back up ...check your setting ....

    Hope this helps

    Bishal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2010 at 02:13 AM

    Hi,

    if you use SQL server backup feature, I do not know your backup type either differential, file or filegroup backups together with the full database backup in your backup plan.

    The SBO backup uses full database backup.

    To know more about the SQL server backup, you may check this link:

    http://www.mssqltips.com/tip.asp?tip=1877

    Rgds,

    JimM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2010 at 08:30 PM

    Try unzipping and restoring one of the back ups as a test system on the server. That will prove whether the back ups are proper or not.

    If you have any issues with a restore, log with SAP

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.