Results 1 to 5 of 5
  1. #1
    Member hungng89's Avatar
    Join Date
    May 2010
    Location
    VietNam
    Posts
    115
    Thanks
    4
    Thanked 2 Times in 2 Posts

    Question Some database of MS SQL Server can't be backed up using TDP for database

    Dear everyone

    I have installed TDP for SQL on my SQL Server . The TDP backup goes well with 8/10 database . Only 2 database GVSIS GVSIS_DEV can't be backed up , the problem seem come from MSSQP , but i can manually backup them using MSSQL Backup ultilitiy
    Code:
    04/20/2011 17:00:47 ============== Log file pruned using log retention period of 60 day(s)
    04/20/2011 17:00:47 ============== No log entries pruned
    04/20/2011 17:00:47 =========================================================================
    04/20/2011 17:00:47 =========================================================================
    04/20/2011 17:00:47 Request                       : FULL BACKUP
    04/20/2011 17:00:47 Database Input List           : *
    04/20/2011 17:00:47 Group Input List              : -
    04/20/2011 17:00:47 File Input List               : -
    04/20/2011 17:00:47 Number of Buffers             : 3
    04/20/2011 17:00:47 Buffer Size                   : 1024
    04/20/2011 17:00:47 Number of SQL Buffers         : 0
    04/20/2011 17:00:47 SQL Buffer Size               : 1024
    04/20/2011 17:00:47 Number of Stripes specified   : 1
    04/20/2011 17:00:47 Estimate                      : -
    04/20/2011 17:00:47 Truncate Log?                 : -
    04/20/2011 17:00:47 Wait for Tape Mounts?         : Yes
    04/20/2011 17:00:47 TSM Options File              : C:\Program Files\Tivoli\TSM\TDPSql\dsm.opt
    04/20/2011 17:00:47 TSM Nodename Override         : -
    04/20/2011 17:00:47 Sqlserver                     : GVLHCMHOSQL01\PRODUCT
    04/20/2011 17:00:47  
    04/20/2011 17:00:47 Backup of SQL Database GVSIS will not be attempted.
    04/20/2011 17:00:47 ACO5422E Received the following from the MS SQL server:
    04/20/2011 17:00:47 Specified cast is not valid. (HRESULT:0x80004002)
    04/20/2011 17:00:47 Backup of SQL Database GVSIS_DEV will not be attempted.
    04/20/2011 17:00:47 ACO5422E Received the following from the MS SQL server:
    04/20/2011 17:00:47 Specified cast is not valid. (HRESULT:0x80004002)
    Does any one has any advice ?

    Thanks and Best Regards
    Sincerely yours

    Hung Nguyen Gia
    hungng89@gmail.com

  2. #2
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,191
    Thanks
    1
    Thanked 25 Times in 24 Posts

    Default

    Looks to be a DB structural integrity issue. You probably need to audit/fix the bad table(s) or record(s).

    This person had the same issues> http://adsm.org/forum/showthread.php...P-MSSQL-backup
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  3. The Following User Says Thank You to chad_small For This Useful Post:

    hungng89 (05-18-2012)

  4. #3
    Member hungng89's Avatar
    Join Date
    May 2010
    Location
    VietNam
    Posts
    115
    Thanks
    4
    Thanked 2 Times in 2 Posts

    Default

    Dear all

    As we can backup all remain database to TSM Server , the issue can only come from MSSQL
    database setting include : Access Right , Structural , Configuration, Database Logical Files setting.

    After doing a health check on your Microsoft SQL Server , i can clarified the issue root cause come
    from Page Verify Configuration

    Issue root cause:
    ================================================== ===========================
    Database page verify method on Microsoft SQL Server Database GVSIS
    and GVSIS_DEV is Torn page detection. Torn page detection does not
    completely fix a DB structural integrity issue.
    ================================================== ===========================

    Setting changed:
    ================================================== ===========================
    Page verify configuration changed from Torn page detection to Checksum
    ================================================== ===========================


    Thanks and Best Regards.
    Sincerely yours

    Hung Nguyen Gia
    hungng89@gmail.com

  5. #4
    Newcomer
    Join Date
    Dec 2011
    Posts
    1
    Thanks
    0
    Thanked 2 Times in 1 Post

    Default

    Hello hungng89,

    I think solutions are

    TDP - Put QUERYOPTIMIZATION 0 in tdpsql.cfg (Configuration file by default) or SQL - sp_dboption 'MyTroubleDatabase', 'autoclose', 'FALSE'
    for each affected database.
    Rgds

  6. The Following 2 Users Say Thank You to eric06 For This Useful Post:

    hungng89 (05-18-2012), Moebius (05-14-2012)

  7. #5
    Member
    Join Date
    Jul 2008
    Location
    Italy
    Posts
    39
    Thanks
    2
    Thanked 1 Time in 1 Post

    Default

    Thanks eric06! I had the same problem, and your solution solved it.
    This was also referenced here:
    http://www-01.ibm.com/support/docvie...id=swg1IC79581

  8. The Following User Says Thank You to Moebius For This Useful Post:

    hungng89 (05-18-2012)

Similar Threads

  1. TDP for SQL Server - restoring Database to another server
    By director_den in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 09-30-2011, 06:44 AM
  2. Replies: 9
    Last Post: 02-22-2011, 05:04 PM
  3. SQL server Database backup is getting Failed on one Database
    By radhar in forum TDP/Application Layer Backup
    Replies: 7
    Last Post: 07-01-2010, 11:41 AM
  4. TDP SQL on cluster unable to backup SQL Database
    By sailesh in forum Backup / Archive Discussion
    Replies: 8
    Last Post: 07-12-2007, 05:43 AM
  5. Restoring a SQL database with TSM SQL server TDP v5.1.5.0
    By gavinring in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 07-15-2004, 04:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •