Restoring Using DMO - Getting File List and No Recovery

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 12, 2002 at 12:00 am

  #151748

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/restoringusingdmogettingfilelistandnorecovery.asp>http://www.sqlservercentral.com/columnists/awarren/restoringusingdmogettingfilelistandnorecovery.asp

  Andy
  Connect with me on LinkedIn

• JimD

  SSC Rookie

  Points: 39

  More actions

  October 19, 2002 at 12:00 am

  #438939

  No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

• smnavis

  SSC Rookie

  Points: 35

  More actions

  November 28, 2002 at 9:56 pm

  #442653

  Using SQL DMO is interesting and also the article from Andy. Thank You Andywarren.

  But I would apreciate anybody if you could let me know how to restore a particular file which are listed in the backupdevice. The situation is :

  I have scheduled to take differential backups followed by a full backup. Now I want to do this :

  - how to list all files of the bkup device

  - how my end user will select a file to be restored

  - how will I specify that file in the DMO to restore ( First let the full backup file be restored and then the selected file )

  Navis

  
  Navis