If I reinstall the virtual center server and create a new database what inofomration will be lost from the old database

Due to the few power shutdown, the SQL installation and the database of the virtual centre is corrupted.  I would like to install again and it is giving two options 1. to use the existing database or 2. Create a new database with SQL MSDE.  I would like to find out if take the 2nd option, what information i would need from the old database.
elawAsked:
Who is Participating?
 
Paul SolovyovskyConnect With a Mentor Senior IT AdvisorCommented:
I just did this yesterday.  You do not lose any VMs obviously but you do lose the resource pool information, roles/permissions, VC logs, and just about anything that is VC specfic.  

You should not use SQL MSDE, VMWare recommends SQL 2005 Express if you go that route.
0
 
elawAuthor Commented:
So is there a work around so that we dont loose the resourse pool information, roles/permissions.
0
 
elawAuthor Commented:
Please let me know if the root permissions will be dropped as well and we have to redefine.  or Atleast the root permissions will be there and we could use its existing password.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Paul SolovyovskySenior IT AdvisorCommented:
When you re-install VC you'll have to add all the hosts back in.  Since access to VC is based per local adminstrators by default then you should have access to VC once you re-install as long as you have local admin access on the machine itself.
0
 
Paul SolovyovskySenior IT AdvisorCommented:
The only workaround not to lose the information is to use the same database, since it keeps all the settings at least from my experience.
0
 
elawAuthor Commented:
Is it difficult to redefine the all the resource pool settings etc.  I m using 2.5 version
0
 
elawAuthor Commented:
if I want to create a SQL database for this purpose then what will be the table and fileld structure.  Sorry i m using 2.02 version for the ESX servers.
0
 
kumarnirmalCommented:
What version of VirtualCenter are you using ?
0
 
elawAuthor Commented:
paulsolov - Since you have performed the same operation, could you please send me the steps you taken to reconfigure the VMWare configuraiton.
0
 
Eugene ZCommented:
... probably all user info will be lost
...do you have good full backup of the sql server databases?
0
 
elawAuthor Commented:
Version for ESX 3.0.2, 52542
Version for Virtual centre server 2.0.2
No backup for the database

If we reinstall the Virtual centre server and create a new database, would it have any issues for the running production VM's.  I know we will have to redefine the roles / permissions, resourece pools, etc.  If someone has done this before would know exact steps taken.  Paulsolov mentioned that he done the same thing.
0
 
Eugene ZConnect With a Mentor Commented:
so you have no backup of VM too?
How did you created it first time?

Do the same way
0
 
elawAuthor Commented:
We have not created.  This is the reason we are asking the details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.