HP Clustered Gateway Device Management Software manual Access check

NOTE:

The Validation step verifies only that the database exists; it does not check the status of the database. If the database is not online and accessible, the create/backup/restore operations will fail.

Access check

To check for access to the backup directory, MxMigrate executes the following from the source and target server:

Exec master..xp_cmdshell N'dir <backup_path or restore_path>

This step requires that xp_cmdshell execution be allowed during the migration. To turn on xp_cmdshell on SQL 2005/2008, use the SQL Surface Area Configuration tool or run the following script.

--enable xp_cmdshell for sql2k5 exec sp_configure 'show advance','1' reconfigure with override

go

exec sp_configure 'xp_cmdshell','1' reconfigure with override

go

To turn off xp_cmdshell on SQL 2005/2008, use the SQL Surface Area Configuration tool or run this script.

--disable xp_cmdshell for sql2k5 exec sp_configure 'xp_cmdshell','0' reconfigure with override

go

Validation process

In addition to validating access, the validation process can save the results of the validation to a file and can create any missing databases on the target server.

HP PolyServe Migration Utility for SQL Server user guide 19