SQLServerCentral / Discuss Content Posted by Andy Warren / Article Discussions / Article Discussions by Author / Restoring Using DMO - Getting File List and No Recovery / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 02:35:53 GMT20RE: Restoring Using DMO - Getting File List and No Recoveryhttp://www.sqlservercentral.com/Forums/Topic7413-29-1.aspxUsing 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 )NavisThu, 28 Nov 2002 21:56:00 GMTsmnavisRE: Restoring Using DMO - Getting File List and No Recoveryhttp://www.sqlservercentral.com/Forums/Topic7413-29-1.aspxNo 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!Sat, 19 Oct 2002 00:00:00 GMTJimDRestoring Using DMO - Getting File List and No Recoveryhttp://www.sqlservercentral.com/Forums/Topic7413-29-1.aspxComments posted to this topic are about the content posted at <A HREF=<A HREF=http://www.sqlservercentral.com/columnists/awarren/restoringusingdmogettingfilelistandnorecovery.asp>http://www.sqlservercentral.com/columnists/awarren/restoringusingdmogettingfilelistandnorecovery.asp</A>><A HREF=http://www.sqlservercentral.com/columnists/awarren/restoringusingdmogettingfilelistandnorecovery.asp>http://www.sqlservercentral.com/columnists/awarren/restoringusingdmogettingfilelistandnorecovery.asp</A></A>Sat, 12 Oct 2002 00:00:00 GMTAndy Warren