Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.) (702 Views)
Reply
Frequent Advisor
Franca86
Posts: 65
Registered: ‎08-12-2011
Message 1 of 10 (939 Views)

Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

Hi folks,

 

I'm trying to restore an old SQL Database, all attempts I got the following error:

 

Received ABORT request from RSM (ERR: Media Agent aborted.)

 

And my session was aborted.

 

How I solve this issue?

 

Thank you.

Frequent Advisor
srik9866
Posts: 54
Registered: ‎07-15-2011
Message 2 of 10 (905 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

hi ,

can you send detailed session report for understanding problem.

Regards,
sri
Frequent Advisor
Franca86
Posts: 65
Registered: ‎08-12-2011
Message 3 of 10 (898 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

[Normal] From: RSM@yyy-yyy-yyy.xxx.local "" Time: 21/12/2012 17:42:37
Restore session 2012/12/21-94 started.

[Normal] From: OB2BAR_Main@aaa-sql-zzz.xxxx.local "(DEFAULT)" Time: 21/12/2012 17:42:40

Hewlett-Packard Data Protector Backup and Restore Agent for Microsoft SQL Server 7.0/2000

connected to SQL Server version 10.0 on machine AAA-SQL-ZZZ

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)
Sep 21 2011 22:45:45
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )


[Normal] From: OB2BAR_Main@aaa-sql-zzz.xxxx.local "(DEFAULT)" Time: 21/12/2012 17:42:40
Character set: Latin1-General
Sort order : case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive


[Normal] From: OB2BAR_Main@aaa-sql-zzz.xxxx.local "(DEFAULT)" Time: 21/12/2012 17:42:41

Database name : 'Database'
Target SQL Server : 'aaa-sql-zzz.xxxx.local'
Source SQL Server : 'bbb-rmltda-zzz.xxxx.local'
Versions to be restored:

Session: 2012/01/31 0008, parallelism: 1, type: full

[Normal] From: OB2BAR_Main@aaa-sql-zzz.xxxx.local "(DEFAULT)" Time: 21/12/2012 17:42:41
SQL statement:
RESTORE DATABASE (Database31JAN) FROM
VIRTUAL_DEVICE = "Data Protector_(DEFAULT)_CorporeSap_17_42_39"
WITH RECOVERY, MOVE "Database_log" TO "G:\Database_log.ldf",MOVE "Database_FG1_Dat1" TO "G:\Database_FG1_Dat1.mdf",MOVE "Database_FG1_Dat2" TO "G:\Database_FG1_Dat2.mdf",MOVE "Database_Primary" TO "G:\Database_Primary.mdf";

[Normal] From: OB2BAR_Main@aaa-sql-zzz.xxxx.local "(DEFAULT)" Time: 21/12/2012 17:42:41
Starting the restore of the database Database
Version: '2012/01/31 0008'. Type: 'full'.

[Major] From: OB2BAR_Database_0@aaa-sql-zzz.xxxx.local "DATABASE" Time: 21/12/2012 17:42:42
Received ABORT request from RSM (ERR: Media Agent aborted.)

[Normal] From: OB2BAR_Main@aaa-sql-zzz.xxxx.local "(DEFAULT)" Time: 21/12/2012 17:42:43

Database statistics:

--------------------------------------------------------------
--------------------------------------------------------------
[Normal] From: RSM@yyy-yyy-yyy.xxx.local "" Time: 21/12/2012 17:42:43
OB2BAR application on "aaa-sql-zzz.xxxx.local" disconnected.

 

Frequent Advisor
Franca86
Posts: 65
Registered: ‎08-12-2011
Message 4 of 10 (858 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

Any suggestions?

 

 

Thanks.

Frequent Advisor
Franca86
Posts: 65
Registered: ‎08-12-2011
Message 5 of 10 (797 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

Happy new year folks!

 

 

Please, help-me.

Trusted Contributor
jruffer
Posts: 184
Registered: ‎06-28-2011
Message 6 of 10 (777 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

What version of Data Protector are you using?

 

The log suggests a mismatch.

Hewlett-Packard Data Protector Backup and Restore Agent for Microsoft SQL Server 7.0/2000

 

Your target appears to be SQL 2008 (X64).  Was this the source of the backup?

 

Jeremy

Frequent Advisor
Franca86
Posts: 65
Registered: ‎08-12-2011
Message 7 of 10 (757 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

Hi,

 

My DP version is 6.11

 

The source of Databases is SQL 2005 x64

The target is  SQL 2008 x64.

 

Thank you.

Trusted Contributor
jruffer
Posts: 184
Registered: ‎06-28-2011
Message 8 of 10 (754 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

[ Edited ]

It might be worth asking in a MSSQL forum but AFAIK you can't restore a SQL 2005 database onto  a SQL 2008 installation.

 

There may be a work round but we've even found that a create table script generated on 2005 fails with syntax errors on 2008.

 

It might be worth trying the restore in debug mode to see if you get any more information.

 

Jeremy

Honored Contributor
danielbraun
Posts: 720
Registered: ‎07-07-2010
Message 9 of 10 (746 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

Hi, in addition please check if the database on the new server has an owner (if not restore cannot continue - have seen this several times) and if restore is allowed. Best regards Daniel
-----------
Please assign Kudos - How to assign...
Frequent Advisor
Franca86
Posts: 65
Registered: ‎08-12-2011
Message 10 of 10 (702 Views)

Re: Trying to restore SQL - Received ABORT request from RSM (ERR: Media Agent aborted.)

Thanks folks.

 

I try to restore on other server, with SQL2005, but I got the same fail error.

 

The version of SQL in New Server is:

 

Microsoft SQL Server 2005 - 9.00.5000.00 (X64)
Dec 10 2010 10:38:40
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

 

I will ask for my DBA about the owner.

 

Thank you.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.