I'm trying unsuccessfully to back up a database from a flash drive. See the sequence and error message below. I'm running SQL Server Express 2014 on Windows 8.1.
use master; go backup database Staging to disk = 'e:\temp\StagingDisk.bak' with init; go
use [master]; go restore filelistonly from disk = N'e:\temp\StagingDisk.bak' go alter database Staging set single_user with rollback immediate restore database Staging from disk = N'e:\temp\StagingDisk.bak' WITH REPLACE, move N'StagingDisk.mdf'to N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\Staging.mdf', move N'StagingDisk.ldf' to N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\Staging.ldf' alter database Staging set multi_user; go
The backup is successful but here's the error I get on the restore:
2 row(s) affected) Msg 3234, Level 16, State 2, Line 14 Logical file 'StagingDisk' is not part of database 'Staging'. Use RESTORE FILELISTONLY to list the logical file names. Msg 3013, Level 16, State 1, Line 14 RESTORE DATABASE is terminating abnormally.