HP Systems Insight Manager - Manual (Page 524)

@step_name = 'Backup INSIGHT Data',
@subsystem = 'TSQL',
@command = 'BACKUP DATABASE "Insight_v*" TO DISK
=''c:\INSIGHT.dat_bak''',
@on_success_action = 3,
@retry_attempts = 5,
@retry_interval = 5
go
-- Add job step (backup log).
USE msdb
EXEC sp_add_jobstep
@job_name ='mydbBackupJob',
@step_name = 'Backup INSIGHT Log',
@subsystem = 'TSQL',
@command =<command> 'BACKUP LOG "Insight_v*" TO DISK' =
'c:\INSIGHT.log_bak''',
@on_success_action = 1,
@retry_attempts = 5,
@retry_interval = 5
go
--Add the target servers.
USE msdb
EXEC sp_add_jobserver @job_name = 'mydbBackupJob',
@server_name = N'(local)'
-- Run job. Starts the job immediately.
USE msdb
EXEC sp_start_job @job_name ='mydbBackupJob'
-- The file has to be copied under /mssql/binn folder
-- The command to execute it is OSQL -Smysqlserver
-U sa -P password if any -i mybackup.sql -n
Restoring files for use with MSDE
Microsoft Access 2000 includes the RESTORE command in the Database Utilities menu of an Access
project for restoring an MSDE database. If SQL Client Tools are installed, SQL Enterprise Manager can also
be used to restore an MSDE database.
Restoring data files for MSDE:
1. If HP SIM is running, stop the HP SIM service and any HP SIM plug-in applications, such as HP ProLiant
Essentials Performance Management Pack.
2. Using the file management tool of your choice, restore the directories and files listed below. For each
occurrence of <SIM>, substitute the actual path name where HP SIM is located.:
Note: A tool that preserves file permissions (such as Windows Backup tool) must be used while restoring
directories and files.
524 Administering systems and events