We're using Sql Server 2005, Win2003 and writing backups to an HP Ultrium2
tape drive.

I can get a File List from the tape with no problems. I'm backing up 14
individual databases to the tape.

I want to create a copy of the "sec" database that has a full backup in
position #11 on the tape. I want to recover the "sec" database as
"sec_2008-11-24". I've successfully created this type of restore many
times when the .bak file is physically on the server harddrive.

However, when I use the following script I get the error message listed
below the script. ANY HELP OR SUGGESTIONS WOULD BE GREATLY APPRECIATED !!

Thanks in advance !

Barry in Oregon

== RESTORE SCRIPT ==
RESTORE DATABASE [sec_2008-11-08]
FROM [HP-Ultrium2-Tape] WITH FILE = 11,
MOVE N'sec_data_001.mdf' TO N'C:\Sql Server
2005\owrd\MSSQL.1\MSSQL\DATA\sec_data_2008-11-08.mdf',
MOVE N'sec_log_001.ldf' TO N'C:\Sql Server
2005\owrd\MSSQL.1\MSSQL\DATA\sec_log_2008-11-08.ldf',
NOUNLOAD,
STATS = 10
GO

== RESULTING ERROR MESSAGE ==

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote:

The error message says it all:

Msg 3234, Level 16, State 2, Line 1
Logical file 'sec_data_001.mdf' is not part of database 'sec_2008-11-08'.
Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

This message is telling you that you cannot MOVE the database with a
logical file name 'sec_2008-11-08.mdf'. Modify the MOVE statement to
reference the actual logical file name that is defined for that backup.

As the error message states - Use RESTORE FILELISTONLY to identify the
actual logical file names for the database you are restoring. Note: you
cannot rename or modify the logical names until after the database has
been restored (and, you can have the same logical file names pointing to
different databases).

Jeff

frostbb wrote: