beautypg.com

Access check, Validation process, 19 validation process – HP PolyServe Software User Manual

Page 19

background image

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

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 4.1 user guide

19