VMware Cloud Community
OUHSC
Contributor
Contributor
‎10-08-2009 08:41 AM

Separate Databases for SRM?

With SRM 4.0 out now, we're moving forward with our install in our DR site but I was needing to clear some things up.

Do you need to have 4 separate DBs? (2 vCenter DB's, one for each vCenter and then 2 SRM databases, one for each site)?

I ask because our SQL 2008 server is clustered with servers here at the production site and the DR site already so we're not using any local DBs.

0 Kudos
2 Replies
AndreTheGiant
Immortal
Immortal
‎10-08-2009 09:00 AM

You need different DB, but not necessary different DBMS server.

Andre

Andrew | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
0 Kudos
ServerMonkey
Contributor
Contributor
‎10-12-2009 10:10 PM

The minimum setup requires:

  • 1 SQL Server in Prodcution (Protected Site)

  • 1 SQL Server in DR (Recovery Site)

Each SQL Server should be site specific, you don't want to replicate the databases or the datastores they reside on.

I'd highly recommend you invest some time in reading the administration guide, this isn't something you just slap in and away it goes.

If you do nothing else head the above and ensure your SQL Server software is compatible, SQL collations and database recovery mode is set correctly.

Run into any issues or have questions after reading the documentation post here in the forums and we'll gladly lend a hand.

0 Kudos