There are several reasons where you will get this error, but I’m going to talk about the one I faced and can be fixed in seconds. I was working with an IMDB dataset. The reason for my error was a database rename. I created the database initially with the name “IMDB” and later renamed it to “IMDB_001”.

Command:

CREATE DATABASE IMDB_001_snapshot ON ( NAME = IMDB_001, FILENAME ='--path--\IMDB_001_snapshot.ss' ) AS SNAPSHOT OF IMDB_001;

Error: All files must be specified for database snapshot creation. Missing the file “IMDB”. (5127) (SQLExecDirectW)’)

Fix (Using SSMS):

Right-click on the database > Properties > (left menu)Files > Rename the file logical names to current database name (in my case to IMDB_001)