How do you backup and restore a database as a copy on the same server?

RESTORE FILELISTONLY is an informational command and is not required to perform a restore. A user can use this to figure out what the logical names are for the data files, that can be used with the MOVE commands to restore the database to a new location.

As suggested by the error message you need to use RESTORE FILELISTONLY to see what the logical names for the database are. Your restore command has these wrong.

Here is a working example of what you need to do:

--backup the databasebackup database test1 to disk='c:\test1_full.bak'-- use the filelistonly command to work out  what the logical names -- are to use in the MOVE commands.  the logical name needs to-- stay the same, the physical name can changerestore filelistonly from disk='c:\test1_full.bak' --------------------------------------------------|  LogicalName  |           PhysicalName           | --------------------------------------------------| test1         | C:\mssql\data\test1.mdf          || test1_log     | C:\mssql\data\test1_log.ldf      | -------------------------------------------------restore database test2 from disk='c:\test1_full.bak'with move 'test1' to 'C:\mssql\data\test2.mdf',move 'test1_log' to 'C:\mssql\data\test2.ldf'

How to: Restore a Database to a New Location and Name (Transact-SQL)

Here are some alternatives:

Database restore (from .BAK) softwares::

1) SqlRestoreSetup

2) Apex SQL Restore