Results 1 to 8 of 8
  1. #1
    Member
    Join Date
    Jun 2005
    Location
    BeiJing, China
    Posts
    47
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default Can I restore MS-SQL DB from difffull backup?

    tdpsql.cmd:

    set sql_dir=C:\TDPSql\TDPSql
    %sql_dir%\tdpsqlc backup "COL_SWITCH" DIFF /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log


    I don't know who set this policy for customer's production MS-SQL Server, everyday they only did a diff backup, not full backup.

    I can not find any full backup for this MS-SQL db.

    So can I restore the db from only difffull backup?
    Last edited by jackyzhang; 07-10-2012 at 11:38 AM. Reason: Attach picture

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,718
    Thanks
    3
    Thanked 207 Times in 202 Posts

    Default

    Yes and you will need the series of incrementals that go along with this diff backup.
    Ed

  3. #3
    Member
    Join Date
    Jun 2005
    Location
    BeiJing, China
    Posts
    47
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    You mean we don't need one full database copy? Just restore from one diffful backup ?

  4. #4
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,718
    Thanks
    3
    Thanked 207 Times in 202 Posts

    Default

    The diff plus all of the previous incrementals and diff - may fail.

    The FULL is always needed by default.
    Ed

  5. #5
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    Jackyzhang, I know you said you can't locate the FULL backup, but run the restore and see what it finds. Add your points in time if you need to do that. It's going to first attempt to restore the FULL so you'll know pretty quickly what it finds or doesn't.

  6. #6
    Member
    Join Date
    Jun 2005
    Location
    BeiJing, China
    Posts
    47
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    When I executed the restore process , TSM did mount the tape volume, but failed quickly.

    TDPSQL Retore GUI display:

    ACO0151E Errors occurred while processing the request.

    Status: Restore failed (HRESULT:0x80131501)

    Please see the attached files.


    01-restore.jpg

    02-tsmsess.jpg

    03-restorefail.jpg

    qact.txt


    Thank you for all guys.

  7. #7
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    As you thought, your FULL is gone. Question is, how did that happen? TDP SQL is not going to deactivate a FULL if there are DIFFs or LOGs that depend on it.

    Set your Window to View Active and Inactive. That said, even if you're only viewing active, a FULL should be there.

  8. #8
    Member
    Join Date
    Jun 2005
    Location
    BeiJing, China
    Posts
    47
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    Hi, Greg,

    The onsite TSM engineer only did diff backup everyday.

    Using this script like this:
    tdpsql.cmd:

    set sql_dir=C:\TDPSql\TDPSql
    %sql_dir%\tdpsqlc backup "COL_SWITCH" DIFF /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log

    So there is no FULL backup at all.
    But the customer still want to restore the SQL database, and I have told them that I need to confirm whether we can restore the SQL database basing on No full backup, just diff backup everyday.

    Thanks.

Similar Threads

  1. Restore of SQL transactionlog to another server with TDP for SQL Restore
    By Piper06 in forum Restore / Recovery Discussion
    Replies: 0
    Last Post: 04-22-2012, 07:32 AM
  2. Replies: 2
    Last Post: 07-24-2009, 02:09 PM
  3. TDP for SQL difffull backup size......
    By Fattire in forum TDP/Application Layer Backup
    Replies: 17
    Last Post: 04-27-2009, 04:18 PM
  4. Backup and Restore of SQL Express
    By wwillsey in forum Restore / Recovery Discussion
    Replies: 10
    Last Post: 03-11-2008, 01:08 PM
  5. "tdpsqlc BACKup * Difffull" always fails when it hits the Master db.
    By cpyne in forum TDP/Application Layer Backup
    Replies: 2
    Last Post: 05-09-2006, 12:21 PM

Posting Permissions

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