Just running backup.bat to move to a new server and keep getting error:
[backup] Backing up DB... Please do not stop this program. [backup] DB logs: Processed 288280 pages for database 'VIM_VCDB', file 'VIM_VCDB_dat' on file 1. Processed 1 pages for database 'VIM_VCDB', file 'VIM_VCDB_log' on file 1. BACKUP DATABASE successfully processed 288281 pages in 754.785 seconds (3.128 MB/sec). [backup] [backup] Msg 8114, Level 16, State 1, Server EIMESXVCSQLEXP_VIM, Line 1 Error converting data type bigint to int. Msg 3013, Level 16, State 1, Server SERVERSQLEXP_VIM, Line 1 RESTORE FILELIST is terminating abnormally. [backup] Error: vCenter Server DB backup failed [backup] Exiting...
I encouter the same problem. It's a standard installation with Virtual Center 2.5 and (standard) sql express instance installed on a VM with Windows 2003 (32bits). Really no fancy things.
Previously I have (once) upgraded to a newer 2.5 build. That upgrade went without any issues.
My instance name is called: SQLEXP_VIM btw.
Processed 1 pages for database 'VIM_VCDB', file 'VIM_VCDB_log' on file 1.
BACKUP DATABASE successfully processed 401425 pages in 159.411 seconds (20.628 MB/sec).
Error converting data type bigint to int.
Msg 3013, Level 16, State 1, Server GRS-SR50\SQLEXP_VIM, Line 1
RESTORE FILELIST is terminating abnormally.
Any thoughts on this?
Oh, and it seems the script did update the database so I cannot start the virtual center 2.5 service anymore..
See this error message when trying to start the "vmware virtualcenter server"
Is this the right time to test the backups?...
I Had the same problem last week
Had a 4.0 vCenter running SQL Express and ran the tool to move the vcenter to a new machine and VCenter 4.1
I used the datamigration tool and yes, it did upgrade the database on the original box.
I recieved the same error "RESTORE FILELIST is terminating abnormally" which meant I could not get the Vcenter functional on the new box running 4.1.
And I could not start the original. The Setup containes "Distrubuted Switches" which made this a very big problem for me.
Eventually I uninstalled vCenter 4.0 on the Original box, installed vCenter 4.1 and pointed to the existing Database. "Keep database in tact" and everything was working again.
Now I will just do the normal exercise of moving the database from SQL Express to Full SQL. (as the client has 30 hosts)
Hope this is helpfull
I ended up with an fresh install of 4.1 on a new vm. Our configuration is quite simple, so I've just configered everything from scratch. That way, I at least have a clean database. And also was the fastest solution for me.
That is good news.
I will normally do that as well, but when you have distributed swithches, it is a whole other ball game. :smileylaugh:
If you import a ESX/ESXi host into the new fresh vCenter, and need to connect it to the new Distributed switch, you loose connectivity on all VMs
And the client went and imported the Service Console into the D-Switch as well
I'm getting the same issue with "RESTORE FILELIST is terminating abnormally"
RESTORE FILELIST is terminating abnormally.
The data migration fails and leave the database prepared for 4.1, with no roll back or anything. A database restore is required. Great tool.
In the vsp_41_upgrade_guide.pdf is no hint that the data migration tool will modify the data on the source ! Are they serious ?
And then the script continous ... there is only one reason to run the script ... to migrate the Database of course.
Thank god I have a snap.
UPDATE: we run the install.cmd without migrating the Database (error as above) (took a new one) after install was completed stopped both vCenter services and sql, on old and new server. Copied the database files fom old to new on. Prey to the IT saint at least 100 times. Start Database and VCenterServer.
Add keys and connect the hosts.
Who says RTFM ? NeverRTFM works better.
I've got the same problem. The source database is partially upgraded but not working well. I found that the tables VPX_HIST_STATx was full of data and they use a bigint as datatype. I flushed the content of the tables and the backup and the upgrade goes smoothly after that.
If you need this historical data, you can probably reimport the data it after the upgrade using SQL tools.
Before starting the backup.bat script go into the folder " \datamigration\vpx\db\" and open dbrestore.sql replace "BackupSizeInBytes int null," with "BackupSizeInBytes bigint null,"
Then the backup script should be sucessfull