Restore Database

I'm trying to restore a data base to a different server
and ame getting this error message
'Logical file x is not part of database x'
can any one explain
Cheers
Can you post the RESTORE command you are executing?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mat" <anonymous@.discussions.microsoft.com> wrote in message
news:041501c48447$0b4719d0$a301280a@.phx.gbl...
> I'm trying to restore a data base to a different server
> and ame getting this error message
> 'Logical file x is not part of database x'
> can any one explain
> Cheers
|||restore database x
FROM TAPE = '\\.\tape0'
with
MOVE datafile TO location,
MOVE logfile TO location,
nounload

>--Original Message--
>Can you post the RESTORE command you are executing?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Mat" <anonymous@.discussions.microsoft.com> wrote in
message
>news:041501c48447$0b4719d0$a301280a@.phx.gbl...
>
>.
>
|||Thanks. It seems that the logical filenames for the database doesn't match the filenames you
specified in the RESTORE command. I suggest you use RESTORE HEADERONLY and RESTORE FILELISTONLY to
verify the logical filenames etc, and based on that construct your RESTORE command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:782b01c48449$d25b3bd0$a401280a@.phx.gbl...[vbcol=seagreen]
> restore database x
> FROM TAPE = '\\.\tape0'
> with
> MOVE datafile TO location,
> MOVE logfile TO location,
> nounload
>
> message
|||Cheers
We have already done that and they match
>--Original Message--
>Thanks. It seems that the logical filenames for the
database doesn't match the filenames you
>specified in the RESTORE command. I suggest you use
RESTORE HEADERONLY and RESTORE FILELISTONLY to
>verify the logical filenames etc, and based on that
construct your RESTORE command.[vbcol=seagreen]
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:782b01c48449$d25b3bd0$a401280a@.phx.gbl...
server
>
>.
>
|||I see. I'm afraid that we can't be of much help here if you don't post the output from these
statements and the exact restore command you try to execute. Basically, we don't have anything to go
on.
You might want to open a case with MS support if you feel that you have constructed the statement
correctly and that SQL Server behaves in some erratic way.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mat" <anonymous@.discussions.microsoft.com> wrote in message
news:751601c4844c$e2127d60$a501280a@.phx.gbl...[vbcol=seagreen]
> Cheers
> We have already done that and they match
> database doesn't match the filenames you
> RESTORE HEADERONLY and RESTORE FILELISTONLY to
> construct your RESTORE command.
> server
|||Is it possible that
There are multiple backups on the tape and you are getting the wrong one
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:782b01c48449$d25b3bd0$a401280a@.phx.gbl...[vbcol=seagreen]
> restore database x
> FROM TAPE = '\\.\tape0'
> with
> MOVE datafile TO location,
> MOVE logfile TO location,
> nounload
>
> message
|||Ahh, OK. Glad you found it. As you probably notice, we tend to ask for exact output and the command
executed. This is just to spot things like this. It is easy to forget that a backup set (especially
when backing up to disk) can have several files in it, something that Wayne picked up on... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mat" <anonymous@.discussions.microsoft.com> wrote in message
news:78b901c48453$dcc6e1f0$a401280a@.phx.gbl...[vbcol=seagreen]
> Thanks Tibor, the problem has ironed its self our. THe DBA
> who refered the question to me assured me that he was
> selecting the correct backups within the back up set, alas
> he wasn't...thanks for your help
> Mat
> you don't post the output from these
> execute. Basically, we don't have anything to go
> that you have constructed the statement
> message