Description

How to move the LANDesk database to another server?

LANDesk database can move as follows:

From SQL 2000 to SQL 2000

From SQL 2005 to SQL 2005

From the same version of Oracle to the same version Oracle.

Resolution

To move a database between servers where both are running SQL 2000 SP4 do the following:

1. Back up the database on the original SQL server.

2. Restore the database to the new server.

3. Create the same user on the new database. Or if desired create a new user.

4. Alias the user to DBO, using this query.

SP_ADDALIAS username, dbo

5. Close the Console on the Core Server.

6. Close any an all Remote Console connections.

7. On the Core Server open Configure Services.

ManagementSuite\SvcCfg.exe

8. On the General tab, change the server name to the name of the new database.

9. If a new username was used, replace the username as well.

10. Click Ok.

11. Reboot the Core Server.

Comments