Does SAP support second filegroup on SQL Server?

[Former Member]

Hi, experts,

Is SAP going to support 2nd filegroup (other than PRIMARY) in MS SQL Server 2005 or 2008? I have implemented that in MS SQL Server, but not with SAP. I see no reason SAP can't support it. I have implemented the similar thing in Oracle, with tablespace I created.

Any comment on the pros and cons?

Dwight

[Former Member · Accepted solution]

Hi Dwight,

please have a look at this [Whitepaper|http://blogs.msdn.com/saponsqlserver/archive/2009/06/24/new-sap-on-sql-server-2008-whitepaper-released.aspx] and search for section SAP and SQL Server Filegroups. That should answer your question.

Sven

[Former Member · Accepted solution]

Thanks, Sven.

Dwight