I have a SQL 2000 database in production (TMS). I have a backup archive of this database from 2011 that I need to restore as a new database. I have to restore to the same server as it is SQL 2000 and we only have one SQL 2000 server.
When I go to restore the database I wanted to change the filename and logical name, to be sure that I don't break anything with the current database in production. I receive the following error message:
Logical file 'TMS_Archive2011_Log' is not part of database 'TMS_Archive2011'. Use RESTORE FILELISTONLY to list the logical file names.
RESTORE DATABASE is terminating abnormally.
How do I proceed with restoring this database, as a new database with a different name, to the same SQL Server, without breaking what's currently in production?
(Am I correct that I cannot restore this backup to a SQL 2008 server?)