VMware VCENTER CONFIGURATION MANAGER FOUNDATION CHECKER 3.0 Guia de Instalação descarregar pdf (Página 208)

Appendix B Transferring the Configuration Database

E.g.1)

> sqlcmd -E -S (local)\SSCCMDB -Q "create database pvminf"

E.g.2)

> sqlcmd -E -S (local)\SSCCMDB

1> create database pvminf

2> go

5. Restarting the service

Click the Start menu, and click Control Panel. From Control Panel, double-click

Administrative Tools. From Administrative Tools, and double-click Services to

start the Services Snap-in on the SERVER1.

Right-click the following service and click Restart.

Displayed Name: SQL Server (SSCCMDB)

Service Name: MSSQL$SSCCMDB

6. Transferring the database to the SERVER1

Restore the file backed up in the procedure 1.

Put the backup file on the local disk of SERVER1 in advance. In the following

example, the name of the backup file is set as C:\temp\backup.dat.

E.g.1)

> sqlcmd -E -S (local)\SSCCMDB -Q "restore database

pvminf from disk = 'C:\temp\backup.dat' with replace"

E.g.2)

> sqlcmd -E -S (local)\SSCCMDB

1> restore database pvminf from disk =

‘C:\temp\backup.dat’ with replace

2> go

7. Creating SQL Server login

Run the following command on a command prompt window of SERVER1. Always

use pvminf as the database name used as the configuration database.

> sqlcmd –E –S (local)\SSCCMDB

1> CREATE LOGIN [Login Name] FROM WINDOWS WITH

DEFAULT_DATABASE=[pvminf]

2> go

1> EXEC master..sp_addsrvrolemember @loginame = N'Login

Name', @rolename = N'sysadmin'

2> go

1> exit

1 2 ... 203 204 205 206 207 208 209 210 211 212 213 ... 228 229

Sem comentários

VMware VCENTER CONFIGURATION MANAGER FOUNDATION CHECKER 3.0 Guia de Instalação Página 208