HP Data Protector 6.2 software integration with HP 3PAR Storage System
56
============================================================================
Session completed successfully!
============================================================================
Microsoft SQL Server Transaction Log Restore
The following is a sample of the Microsoft SQL Server restorep-session report with the session id
2011/04/18-41 where only transaction logs are being restored:
[Normal] From: RSM@ita030.deu.hp.com "" Time: 4/18/2011 9:31:25 PM
Restore session 2011/04/18-41 started.
[Normal] From: OB2BAR_Main@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:16 PM
Hewlett-Packard Data Protector Backup and Restore Agent for Microsoft SQL Server
connected to SQL Server version 10.50 on machine TPC193
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
[Normal] From: OB2BAR_Main@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:16 PM
Character set: Latin1-General
Sort order : case-insensitive, accent-sensitive, kanatype-insensitive, width-
insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
Data
[Normal] From: OB2BAR_Main@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:17 PM
Database name : 'DB1_3PAR'
Target SQL Server : 'tpc193.tic.dp'
Source SQL Server : 'tpc193.tic.dp'
Versions to be restored:
Session: 2011/04/18 0036, parallelism: 1, type: transaction log (incremental)
[Normal] From: OB2BAR_Main@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:17 PM
SQL statement:
RESTORE LOG (DB1_3PAR) FROM
VIRTUAL_DEVICE = 'Data Protector_(DEFAULT)_DB1_3PAR_192816802_0'
WITH NORECOVERY, BLOCKSIZE = 4096;
[Normal] From: OB2BAR_Main@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:17 PM
Starting the restore of the database DB1_3PAR
Version: '2011/04/18 0036'. Type: 'transaction log (incremental)'.
[Normal] From: RMA@tpc194.tic.dp "FL194_Writer0" Time: 4/18/2011 9:28:52 PM
STARTING Media Agent "FL194_Writer0"
[Normal] From: RMA@tpc194.tic.dp "FL194_Writer0" Time: 4/18/2011 9:28:53 PM
Loading medium from slot C:\FL1\10394b8254dac54f4551665009d.fd to device
FL194_Writer0
[Normal] From: OB2BAR_DB1_3PAR_0@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:55 PM
Starting OB2BAR Restore: tpc193.tic.dp:/(DEFAULT)/DB1_3PAR/0 "MSSQL"
[Normal] From: OB2BAR_Main@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:56 PM
Restore of database is complete.
Data Protector agent is waiting for SQL Server to finish execution of the SQL
statement.
Database will be left in a non-operational state to allow the restore of additional
backups.
[Normal] From: OB2BAR_DB1_3PAR_0@tpc193.tic.dp "(DEFAULT)" Time: 4/18/2011 9:28:58 PM
Completed OB2BAR Restore: tpc193.tic.dp:/(DEFAULT)/DB1_3PAR/0 "MSSQL"