Is it possible to find out .mdf and .ldf file name from the backup(.bak) file? If yes, then how?

 Posted by Virendradugar on 4/19/2010 | Category: Sql Server Interview questions | Views: 6701
Answer:

YES. It is possible to find out the name of .ldf and .mdf file from the backup file.

Use below script to find out the details:

RESTORE FILELISTONLY FROM DISK='D:\virendra.bak'


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response