Avatar of R W
R W
Flag for United States of America

asked on 

Creating a new Vcenter SQL db

Will this be sufficient enough space for vcenter 6x db?

use [master] 
go 
CREATE DATABASE [vcenterdb] ON PRIMARY 
(NAME = N'vcenterdb', FILENAME = N'C:\vcenterdb.mdf', SIZE = 200000KB, FILEGROWTH = 10% ) 
LOG ON 
(NAME = N'vcenterdb_log', FILENAME = N'C:\vcenterdb.ldf', SIZE = 100000KB, FILEGROWTH = 10%) 
COLLATE SQL_Latin1_General_CP1_CI_AS 
go
use vcenterdb 
go 
sp_addlogin @loginame=[vpxuser], @passwd=N'vpxuser!0', @defdb='vcenterdb', @deflanguage='us_english'
go 
ALTER LOGIN [vcuser] WITH CHECK_POLICY = OFF 
go 
CREATE USER [vcuser] for LOGIN [vcuser]
go
use MSDB
go
CREATE USER [vcuser] for LOGIN [vcuser]
go

Open in new window

Microsoft SQL ServerVMware

Avatar of undefined
Last Comment
R W

8/22/2022 - Mon