t-sql help please

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  November 14, 2010 at 8:36 pm

  #229317

  I need to restore the database daily using a scheduled SQL job. Below is my requirement:

  First time I will have Full db backup file and then from the following day I will have diff db backup files placed in our network folder. So the first time I need to restore the Full db backup file and create the db. And then after that every day I need to restore the diff db backup file. How can I do this using T-sql?

  I will get from my client FullDB.bak file the first time and then from the second day onwards I will be getting the DiffDb files which will be placed on our network folder. Then I need to use those files to restore/update my DB daily.

  Any ideas. Thanks.

• RichardDouglas

  SSCarpal Tunnel

  Points: 4029

  More actions

  November 15, 2010 at 6:38 am

  #1250677

  Is this the same request as here

  Hope this helps,
  Rich

  [p]
  [/p]