SQL Server Management Studio or DB13?

[Former Member]

Hi all, I would like to know if there are some best practices for maintaining a SAP System on SQL Server 2008 R2 Enterprise Edition 64bit.

I am interested in administrative tasks like backup db, backup t-log, checkdb, reindex, alerting, notifications and so on.

We do all these tasks with Management Studio for other databases and this is fine.

What about SAP databases?

Should we use DB13 or can we continue to use Management Studio?

Thank you very much.

Best regards.

[former_member524429]

Hi,

 What about SAP databases?
Should we use DB13 or can we continue to use Management Studio?

You can use DB13. Most of administrative tasks are incorporated in it.

You can refer SQLServerFAQ.zip file attached with [SAP Note 555223 - FAQ: Microsoft SQL Server|https://service.sap.com/sap/support/notes/555223] to get Info.

You can also refer this [Best Practice Document|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548c65] to get more detailed information.

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Jul 13, 2011 4:54 PM

[Former Member]

Thank you very much for your reply.

Best regards.

[Former Member]

Thank you very much for your reply.

Best regards.