<div>
Questions answered adequately. I was able to get the database restored to a SQL 2008 server after a few attempts.<br />
&nbsp;<br />
Useful information regarding the logical filenames.
</div>


Questions answered adequately. I was able to get the database restored to a SQL 2008 server after a few attempts.
 
Useful information regarding the logical filenames.

<div>
<div class="content wysiwyg-content">
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 <b>new database</b>. I have to restore to the same server as it is SQL 2000 and we only have one SQL 2000 server. <br />
<br />
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:<br />
<br />
Logical file 'TMS_Archive2011_Log' is not part of database 'TMS_Archive2011'. Use RESTORE FILELISTONLY to list the logical file names.<br />
RESTORE DATABASE is terminating abnormally.<br />
<br />
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?<br />
<br />
(Am I correct that I cannot restore this backup to a SQL 2008 server?)
</div>
</div>


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?)

Restore SQL Backup to new database with same logical file name

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.