1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

ACO0151E Errors occurred while processing the request

Discussion in 'Microsoft SQL Server' started by shaaha85, Nov 2, 2012.

  1. shaaha85

    shaaha85 New Member

    Joined:
    Nov 23, 2010
    Messages:
    37
    Likes Received:
    0
    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 =======================================================
     
  2.  
  3. Trident

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    288
    Likes Received:
    27
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    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.
     
  4. shaaha85

    shaaha85 New Member

    Joined:
    Nov 23, 2010
    Messages:
    37
    Likes Received:
    0
    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 .
     
  5. Trident

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    288
    Likes Received:
    27
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    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.
     

Share This Page