Move SQL database

[francois_tiers]

Hi,

I've got an VC 2.0.2 build 62327, the database is installed on a MS SQL 2005 (version 9.00.1399.00). For the VC Database the previous installer installed this database into the master DB.

How can i migrate this DB into another DB (VC202) without recreate all data? (data, schema, proc, view, ...)

is it clear?

[cheeko]

Make a full backup of your master DB, restore it to a new DB called VC (or whatever), remove all the unused tables (the tables from the master DB), point VC to the newly created DB.

Verify that all works and then delete the VC stuff out of your master DB.

Something like that ...

[francois_tiers]

When i backup and restore into VC202 DB, no problem, but when i want to restart the VMware VirtualCenter Service?

i have this error : into the vpxd.log file.

Log for VMware VirtualCenter, pid=5380, version=2.0.2, build=build-62327, option=Release, section=2

Current working directory: C:\WINDOWS\system32

Initializing SSL context

Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 120000000

NFC connection accept timeout: 180000 milliseconds

NFC request timeout: 180000 milliseconds

NFC read timeout: 60000 milliseconds

NFC write timeout: 600000 milliseconds

Starting VMware VirtualCenter 2.0.2 build-62327

Log directory: C:\WINDOWS\TEMP\vpx.

Account name: SYSTEM

Enabled low-frag process heap.

Enabled low-frag crt heap.

34 max LROs

6 reserved internal LROs

6 reserved blocker LROs

6 reserved short LROs

4 reserved long LROs

600-second task lifetime

Sequence VPX_ENTITY_SEQ is not defined on the database

Failed to intialize VMware VirtualCenter. Shutting down...

[cheeko]

Did you edit your ODBC DSN to point to the new DB?

[francois_tiers]

Yes !

I change the ODBC driver.

[cheeko]

Did you test your Data source after ODBC change?

Did you already strip off some tables? Try it with the complete restore then (exact copy of your Master DB).

What you could also try is a repair of VC after pointing to the new DB.

[francois_tiers]

i test my database, this DB run correctly.

I've got a exact copy of the master DB...

i will try to re-install but i'm not finding that it's a professional solution...

[cheeko]

try a repair first.

well, i think the unprofessional part started with the the virtual center tables in the SQL master DB ...

[francois_tiers]

i think so...

The people who made the installation was very null...