Database Read only

[Former Member]

Hi All,

Can SAP application connect to read only SQL Server database ?

We are trying to use secondary database of log shipping, for our operational adhoc reporting of production data.

Please let me know.

Thanks

Mushtaq

[Former Member]

Hi Mushtaq,

no, this is not possible. Even if you do not run any reports/transactions which you know will write to the database, the SAP system will run its internal processes and they'll write to the database. For this reason it's not possible to use a read-only DB for an SAP system.

Regards,

Beate

[Former Member]

No, Database has to opened in read_write.