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: 7451

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

Bookmark It

< Previous : what is the difference between garbage collection ...

Next > : Can we restore the database forcefully when it is ...

More Interview Questions by Virendradugar

Latest Interview Questions