on 09-19-2008 9:37 AM
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
Thanks Jimmy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.