VMware – SQL script to create the vCenter 4.1 database

use [master] go CREATE DATABASE [VCDB] ON PRIMARY (NAME = N’vcdb’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQL\DATA\VCDB.mdf’, SIZE = 2000KB, FILEGROWTH = 10%) LOG ON (NAME = N’vcdb_log’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQL\DATA\VCDB.ldf’, SIZE = 1000KB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS go use VCDB go sp_addlogin @loginame=[vpxuser], @passwd=N’@Password’, …