Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Nov 2010
    Location
    Belgium
    Posts
    80
    Thanks
    22
    Thanked 0 Times in 0 Posts

    Post How can I exclude a single database from a TDP MSSQL backup?

    Linux TSM Server 6.2.2.0 - TSM Client 6.2.2.0 - TDP MSSQL 5.5.4.2

    Hi all,

    I had the following lines in my dsm.opt file
    Code:
    INCLUDE "\...\meta\...\*" 
    INCLUDE "\...\data\...\*" 
    EXCLUDE "\...\master\...\log*"
    EXCLUDE "\...\msdb\...\log*"
    A couple of databases can not be backed up due to structural errors so I decided to exclude them by adding the following two lines at the end of the one listed above

    Code:
    EXCLUDE "\...\db1\...\*"
    EXCLUDE "\...\db1-prd\...\*"
    but it still looks like they are being backed up:

    Code:
    03/13/2011 22:03:10 Backup of SQL Database db1 will not be attempted.
    03/13/2011 22:03:10 ACO5422E Received the following from the MS SQL server:
    03/13/2011 22:03:10 Specified cast is not valid. (HRESULT:0x80004002)
    03/13/2011 22:03:10 Backup of SQL Database db1-prd will not be attempted.
    03/13/2011 22:03:10 ACO5422E Received the following from the MS SQL server:
    03/13/2011 22:03:10 Specified cast is not valid. (HRESULT:0x80004002)
    So I'm clearly not doing it properly. How would you do it?
    Last edited by foobar2devnull; 03-14-2011 at 06:35 AM.

  2. #2
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    271
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    Hi,

    Try this
    tdpsqlc backup * full /excludedb=db1,db2,db3
    tdpsqlc backup * log /excludedb=db1,db2,db3
    -= Trident =-

  3. #3
    Member
    Join Date
    Nov 2010
    Location
    Belgium
    Posts
    80
    Thanks
    22
    Thanked 0 Times in 0 Posts

    Default

    Thanks for your help Trident and sorry for the late reply, I was on a TSM course last week.
    The fault was mine, I was excluding a directory rather than simply excluding the db file name

    so I replaced:
    EXCLUDE "\...\db1\...\*"
    with:
    EXCLUDE "\...\db1.*"
    On a side note though, can the command line option excludedb be found in the tdp.opt file?

    Thanks.
    Current Infrastructure:
    TSM Server 7.1 running on Linux Suse 11 SP2 - TSM Clients all running 6.2.2.0 or better - TDPs at latest version.

  4. #4
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    271
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    I do not think you can use the excludedb parameter in dsm.opt

    I have only seen it with tdpsqlc.
    -= Trident =-

  5. #5
    Newcomer
    Join Date
    Oct 2011
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by Trident View Post
    Hi,

    Try this
    tdpsqlc backup * full /excludedb=db1,db2,db3
    tdpsqlc backup * log /excludedb=db1,db2,db3
    This looks about right. This is how I would do it. However, I am running into some real coding issues on a payroll utility that I am working on...(very similar to Paycor), and I could really use some help. I do not wish to discuss the nature of my problem publicly, since I need to keep this project under wraps for the time being until it is ready to launch, so it would be great if someone who is knowledgeable can contact me privately. Thank you.
    Last edited by Tyrese; 10-25-2011 at 04:04 PM.

Similar Threads

  1. Replies: 7
    Last Post: 03-19-2014, 12:46 PM
  2. Backup MSSQL Express without TDP
    By tobi007 in forum Microsoft SQL Server
    Replies: 1
    Last Post: 01-04-2011, 04:58 AM
  3. MSSQL Exprexx Backup with TDP
    By nadeemqaisar in forum Microsoft SQL Server
    Replies: 1
    Last Post: 09-08-2009, 02:59 AM
  4. What to backup with TDP MSSQL
    By GregE in forum TDP/Application Layer Backup
    Replies: 3
    Last Post: 09-26-2007, 12:35 PM
  5. Replies: 6
    Last Post: 06-21-2005, 07:43 AM

Tags for this Thread

Posting Permissions

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