I have a database backup file stored in a hard drive
someFile.bak. The file path is simply
V:\someFile.bak. I have been trying to load this into SQL Server Management Studio via the command
RESTORE DATABASE someDatabase FROM DISK = 'V:\someFile.bak'
but I keep getting the error:
Msg 3201, Level 16, State 2, Line 4 Cannot open backup device 'V:\someFile.bak'. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level 16, State 1, Line 4 RESTORE DATABASE is terminating abnormally.
This suggests to me that SSMS is having issues finding the file path, despite it being specified correctly. Does this have anything to do with the fact that this is from a hard drive rather than from the internal drive (like
C:)? If so, is there a better way to restore a database from the hard drive? I am asking this because
someFile.bak is too large to store on my internal drive.