new1234.jpg

Archive

Posts Tagged ‘Database’

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: Purging old data from the database used by VirtualCenter Server (1000125)

February 18th, 2009 1 comment

VirtualCenter Server stores task, event, and performance data in the VirtualCenter database. Over time, data collection results in growth of the database files and a mechanism is needed to shrink these files. Although there is no feature in the product itself to purge or shrink old records from the database, it is possible to do so manually.

There are two variations of this solution, one for each of the supported VirtualCenter database platforms, Oracle and Microsoft SQL Server.

The attached scripts support purging the data from both VirtualCenter 2.0.x and VirtualCenter 2.5.x.

Note: The Oracle version of the scripts are not combined. When you extract the scripts, run the version of the script for the version of VirtualCenter that is in use.

For the solution check the source out.

Source: 1000125