Database settings in SQL server
Please provide SAP's recommendations for Database Settings when upgarding to BPC 7
1.Compatibility Level. Should it be (80) or (100)?
Compatibility Level of 80 = SQL 2000
Compatibility Level of 90 = SQL 2005
Compatibility Level of 100 = SQL 2008
2. Recovery Model (Simple or Full)
SQL Server 2000 is not supported
Compatibility Level of 90 = SQL 2005 if you are using SQL Server 2005
Compatibility Level of 100 = SQL 2008 if you are using SQL Server 2008
It is depending by the disaster recovery model which customer would like to implement.
If for the customer lossing data for last 24 hours is an accepted then you can use SINGLE
If for the customer the data lost can be in maximum X hours (X< 24) then you have to use FULL.(and you have to implement
the backup maintenance plan according with this requirement).