I have a sql server 2014 database. I just migrated the data from 2008.
I have 4 databases. I have created a .bak copy of every one of them.
So far with 2 of them, I am able to RESTORE from the .bak copy I created.
Two others fail. Below is an example of my script. It is identical for each database, with just the name change.
RESTORE DATABASE [REEKill2012] FROM DISK = N'C:\DBFBackups\Hourly\Ree2005Hourly.bak' WITH FILE = 1, MOVE N'Ree2005' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\REEKill2012.mdf', MOVE N'Ree2005_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\REEKill2012_1.ldf', NOUNLOAD, STATS = 5
when I run it on two of the databases, most important ones of course, I get this error:
Cannot open backup device 'C:\DBFBackups\Hourly\Ree2
bak'. Operating system error 2(The system cannot find the file specified.).
In the screenshot, you can see that the backup exists, and the file size is there too to show there is data.
What can be wrong?