ACO0151E Errors occurred while processing the request

[shaaha85]

Hi Guys,

I am getting below error when try to restore TDP backup.
I can able to restore full backup.But having issue when doing differential restoration.

TDP verson: 5.2.1.0

11/01/2012 02:35:17 Request : QUERY TSM DBNAME
11/01/2012 02:35:17 SQL Server Name Override : ***11/01/2012 02:35:17 Database Input List : *
11/01/2012 02:35:17 Include Inactive Files? : No
11/01/2012 02:35:17 Include Compatibility Info? : Yes
11/01/2012 02:35:17 Include File Info? : No
11/01/2012 02:35:17 FileInfo Mount Wait : Yes
11/01/2012 02:35:17 -------------------------------------------------------------------------
11/01/2012 02:35:34 =========================================================================
11/01/2012 02:35:34 Request : RESTORE
11/01/2012 02:35:34 Database Input List : -
11/01/2012 02:35:34 Object Input List : -
11/01/2012 02:35:34 Group Input List : -
11/01/2012 02:35:34 File Input List : -
11/01/2012 02:35:34 Log or Set Input List : -
11/01/2012 02:35:34 Into Input List : -
11/01/2012 02:35:34 Undo File : -
11/01/2012 02:35:34 Relocate Input List : -
11/01/2012 02:35:34 To Input List : -
11/01/2012 02:35:34 Include Inactive Files? : No
11/01/2012 02:35:34 Number of Buffers : 3
11/01/2012 02:35:34 Buffer Size : 4096
11/01/2012 02:35:34 Number of SQL Buffers : 3
11/01/2012 02:35:34 SQL Buffer Size : 4096
11/01/2012 02:35:34 Number of Stripes specified : 5
11/01/2012 02:35:34 Wait for Tape Mounts? : Yes
11/01/2012 02:35:34 DateTime : -
11/01/2012 02:35:34 MarkName : -
11/01/2012 02:35:34 After : -
11/01/2012 02:35:34 Recovery : Yes
11/01/2012 02:35:34 Replace : No
11/01/2012 02:35:34 Restricted User Only? : No
11/01/2012 02:35:34 Partial? : -
11/01/2012 02:35:34 TSM Options File : C:\Program Files\Tivoli\TSM\TDPSql\dsm.opt
11/01/2012 02:35:34 TSM Nodename Override : -
11/01/2012 02:35:34 Fromsqlserver : ***0211
11/01/2012 02:35:34 Sqlserver : ***9999
11/01/2012 02:35:34
11/01/2012 02:35:35 Restore of Workplac1_SERV failed.
11/01/2012 02:35:35 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot apply the backup on device 'TDPSQL-00000620-0000' to database 'Workplac1_SERV'.
11/01/2012 02:35:35 [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.
11/01/2012 02:35:35 Total database backups inspected: 1
11/01/2012 02:35:35 Total database backups requested for restore: 1
11/01/2012 02:35:35 Total database backups restored: 0
11/01/2012 02:35:35 Total database skipped: 0
11/01/2012 02:35:35 Throughput rate: 10.96 Kb/Sec
11/01/2012 02:35:35 Total bytes transferred: 11,264
11/01/2012 02:35:35 Elapsed processing time: 1.00 Secs
11/01/2012 02:35:35 ACO0151E Errors occurred while processing the request.
11/01/2012 02:36:25 =======================================================

 

[Trident]

Make sure you have the database in restoring mode. Otherwise, it will fail.
Differential restore needs to be applied to a particular full database (in restoring mode), otherwise it will fail.

 

[shaaha85]

Hi,

I can able to restore full backup but cannot apply differential backup(same database).
If the database is not in restore mode how come i can apply full backup and not on differential backup.
Please advise .

 

[Trident]

Using the command line, add /recovery=no when restoring full backup.

From the gui, there is a tick box, that should not be ticked off.