SQL Server database restore error – logical file is not part of database use restore filelistonly to list the logical file names

Today we were getting SQL Server database restore error – logical file is not part of database XXX use restore filelistonly to list the logical file names.

As said in the message run restore filelistonly using sql:
RESTORE FILELISTONLY
FROM DISK = ‘xxx’

And then replace logical name shown by RESTORE FILELISTONLY in the restore sql script.

Thanks to the following post:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s