Wednesday 26 June 2013

Retrieve the files (data file, and log files) name and location path fron sql server backup file

Retrieve the files (data file, and log files) name and location path fron sql server backup file say abc.bak

By using the following sql statement we can retrieve the same :)

RESTORE FILELISTONLY FROM DISK='E:\abc.bak'

No comments:

Post a Comment