new1234.jpg

Archive

Posts Tagged ‘SQL’

VMware: “Datamigration” vSphere 4.1 to 4.1 is not supported

September 13th, 2010 8 comments

We got some problems in the datacenter with the virtual vCenter 4.1 server and decided to revert to a physical machine again to run vCenter.

After some good experience with the VMware Datamigration tool I tried to use this option again to migrate the 4.1 vCenter/VUM database + settings to the new host.. but… it’s not supported!

image

[ERROR] vCenter Server version not supported
[WARNING] vCenter Server does not satisfy migration prerequisite

Too bad!

sanderdaems

Sander Daems is founder and author of this blog and working as a Lead (Sr.) Consultant by UNICA ICT Solutions. Sander has over 15 years experience in IT, primary focus: virtualization and modern worksplace.

More Posts - Website

Follow Me:
TwitterLinkedIn

Categories: VMware Tags: , , ,

VMware: vCenter Datamigration: Msg 3013, BACKUP DATABASE is terminating abnormally

September 2nd, 2010 9 comments

One of my colleagues was migrating vCenter 4.0 database to vCenter 4.1 by using the Datamigration Tool located at the vCenter Installation CD. After running the Backup.bat script he received the following error:

DB logs: Msg. 3013, Level 16, State 1, Server <name> , Line 1 BACKUP DATABASE is terminating abnormally

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..

 

image

Read more…

sanderdaems

Sander Daems is founder and author of this blog and working as a Lead (Sr.) Consultant by UNICA ICT Solutions. Sander has over 15 years experience in IT, primary focus: virtualization and modern worksplace.

More Posts - Website

Follow Me:
TwitterLinkedIn

VMware: Defragmenting VirtualCenter performance data indexes on a Microsoft SQL database (1003990)

March 10th, 2009 1 comment

For troubleshooting or maintenance purposes it may be necessary to defragment the indexes on your Microsoft SQL database server. This article provides the steps perform a defragmentation of the indexes to increase performance of the database.

Overview

Fragmentation of indexes occurs when the logical order of pages is different than the physical order on the disk. In VirtualCenter fragmentation occurs most noticeably due to the statistics collection and consolidation. 

When the indexes are excessively fragmented, performance of queries to the VirtualCenter database is slow.

Warning: The VirtualCenter Server service must be shut down prior to performing any kind of database maintenance. For information on stopping the VirtualCenter Server service, see Stopping, starting, or restarting the VirtualCenter Server service (1003895).

Read more…