Moving a vCenter Protect database from one SQL server to another (2030810)
Note: Before migration, ensure that Microsoft SQL Management Studio is installed on both the current database server and the destination database server. Also, ensure that no user is currently logged in to the vCenter Protect console.
- Open SQL Management Studio on the current database server.
- Set the Server Type field to Database Engine.
- Set the Server name field to the name of the server hosting the database.
Note: Ensure that you are using credentials with sufficient rights to the database server to detach your vCenter Protect database.
After logging in to the database engine using SQL Management Studio, you see the Object Explorer pane on the left side of the window.
- Expand the Databases folder and locate your vCenter Protect database.
- Right-click the vCenter Protect database and click Detach.
- Browse to the directory where the database files are stored on the server.
Note: To find the file path, in SQL Management Studio, right-click the database and click Properties.
- In the window that appears, select the files in the left pane.
- Scroll the right pane to view the Path column.
- Browse to this path in Windows Explorer and copy both databasename.mdf and databasename.ldf files to the destination SQL server.
- Open SQL Management Studio on the destination machine and log in to the database engine.
- Right-click the Databases folder and click Attach.
- In the Databases to attach window, click Add and point it to the databasename.mdf file you copied to the server.
You should now be able to see the MDF and LDF files in the bottom pane.
- Click OK. The database is now attached.
- Link the database to the vCenter Protect installation.
To link the database to the vCenter Protect installation:
- Log in to your vCenter Protect console machine.
- Click Start > All Programs > VMware vCenter Protect.
- Select Database setup tool.
- Select the Use an existing database option and click Next.
- Select the server name of the new database server.
- In the Database Name dropdown, select your vCenter Protect database.
- Choose the credentials that the vCenter Protect console should use to connect to the database.
- Click Test database connection.
- If the test is successful, click Next.
The console should now be attached to this database and vCenter Protect is ready for use.