Migrating db to MSCS

[Former Member]

I have an existing Windows/MS SQL install, and would like to migrate the db to a cluster. Is it possible to bring my db node into a cluster without doing a new install, or do I have to do a new cluster db install + a database import from backup or export?

[former_member433984 · Accepted solution]

completely without new installation would not be possible as you need to:

- detach your existing DB (see SAP note 151603)

- install and cluster MS SQL Server instance (master db is located on shared disk)

- attach your DB (again on shared disks)

[Former Member · Accepted solution]

Yaroslav:

Thanks for the help. Is there a guide or note you could refer me to concerning building the db instance in a MSCS environment? I'm using 'SAP Web Application Server 6.40 SR1 ABAP on Windows: MS SQL Server' component installation guide. Its sort of light on the clustering side of things...

[former_member433984 · Accepted solution]

would be better to look for installation guides -

http://service.sap.com/instguides

clustering routine is described in details there

for detach/attach - note 151603