cancel
Showing results for 
Search instead for 
Did you mean: 

Earlywatch Alert

Former Member
0 Kudos

Hi all,

I receive via the Earlywatch Alert the following warning messages:

Can somebody explain me what the differences are between 'FULL' and 'SIMPLE'

0.1 Database Settings

RECOVERY MODEL OF SBO-COMMON

Rating SBO-Common Recovery Model

FULL

Recommendation: SAP is recommending to set the recovery model of the SBO-Common to "SIMPLE". Please contact your Support Partner and refer to the SAP Business Solution Guide on your product CD to correct the settings.

How do you set this up?

0.2 Size of Transaction Log File of SBO-Common

SIZE OF TRANSACTION LOG FILE OF SBO-COMMON

Rating Transaction Log Path Transaction Log Size [MB]

D:\SBO-COMMON\SBO-COMMON_log.ldf 1817.73

Recommendation: The log size of the SBO-Common file is relatively big. This could indicate a wrong setting in your database. Please contact your support partner and refer to the Solution Guide to verify your database settings and how to shrink the Log-File of the SBO-Common.

The customer using MSSQL2005

Thanks in advance,

Chief

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks Jimmy.

former_member186095
Active Contributor
0 Kudos

Hi,

I recommend to use simple because if you use simple, the log file size growth will not large but if it is full, you will have high file size of transaction log.

To check whether the database use simple or full, just right click SBO common database --> select and click properties --> the database properties window will apears, then select options page then you will see the field recovery model. in this field, you could choose full or simple recovery.

This is an attachment from notes 735950 and relates to your 2nd question:

/* Reduce size of the logfile to 1 MB.... */

USE SBODemo_DE

GO

DBCC SHRINKFILE (SBODemo_DE_Log, 1)

GO

/* Limit the max. size of the logfile to 50 MB

(only works, if current size is less than 50 MB)*/

ALTER DATABASE SBODemo_DE

MODIFY FILE

(

NAME = SBODemo_DE_Log,

MAXSIZE = 50MB

)

GO

/* Sets the size of the logfile to 50 MB

(no growth needed, if max. size is 50 MB => no fragmentation)*/

ALTER DATABASE SBODemo_DE

MODIFY FILE

(

NAME = SBODemo_DE_Log,

SIZE = 50MB,

)

GO

/* Prevent logfile growth */

ALTER DATABASE SBODemo_DE

MODIFY FILE

(

NAME = SBODemo_DE_Log,

FILEGROWTH = 0MB

)

GO

Rgds,

0 Kudos

Hi Chief,

The difference between the Simple and Full recovery models is described in the SQL Server documentation topics u2018Backup Under the Full Recovery Modelu2019 and u2018Backup Under the Simple Recovery Modelu2019.

To change the settings go to a database properties -> Options -> Recovery Model.

Regards,

Pavol