Database settings in SQL server

[raghu_ram]

Hi,

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)

Thanks.

Raghu

[sorin_radulescu · Accepted solution]

Hi Raghu,

For 7.0

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

Recovery Model

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).

Regards

Sorin Radulescu