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.

Can I restore MS-SQL DB from difffull backup?

Discussion in 'Microsoft SQL Server' started by jackyzhang, Jul 10, 2012.

  1. jackyzhang

    jackyzhang New Member

    Joined:
    Jun 13, 2005
    Messages:
    47
    Likes Received:
    1
    Occupation:
    Tivoli Specialist
    Location:
    BeiJing, China
    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: Jul 10, 2012
  2.  
  3. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,226
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Yes and you will need the series of incrementals that go along with this diff backup.
     
  4. jackyzhang

    jackyzhang New Member

    Joined:
    Jun 13, 2005
    Messages:
    47
    Likes Received:
    1
    Occupation:
    Tivoli Specialist
    Location:
    BeiJing, China
    You mean we don't need one full database copy? Just restore from one diffful backup ?
     
  5. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,226
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    The diff plus all of the previous incrementals and diff - may fail.

    The FULL is always needed by default.
     
  6. GregE

    GregE Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    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.
     
  7. jackyzhang

    jackyzhang New Member

    Joined:
    Jun 13, 2005
    Messages:
    47
    Likes Received:
    1
    Occupation:
    Tivoli Specialist
    Location:
    BeiJing, China
    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

    View attachment qact.txt


    Thank you for all guys.
     
  8. GregE

    GregE Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    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.
     
  9. jackyzhang

    jackyzhang New Member

    Joined:
    Jun 13, 2005
    Messages:
    47
    Likes Received:
    1
    Occupation:
    Tivoli Specialist
    Location:
    BeiJing, China
    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.
     

Share This Page