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
Showing posts with label base. Show all posts
Showing posts with label base. Show all posts
Tuesday, March 20, 2012
Monday, March 12, 2012
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
CheersCan 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 t
he filenames you
specified in the RESTORE command. I suggest you use RESTORE HEADERONLY and R
ESTORE FILELISTONLY to
verify the logical filenames etc, and based on that construct your RESTORE c
ommand.
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.
>--
>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[vbcol=seagreen]
>
>.
>|||I see. I'm afraid that we can't be of much help here if you don't post the o
utput from these
statements and the exact restore command you try to execute. Basically, we d
on't have anything to go
on.
You might want to open a case with MS support if you feel that you have cons
tructed 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
and ame getting this error message
'Logical file x is not part of database x'
can any one explain
CheersCan 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 t
he filenames you
specified in the RESTORE command. I suggest you use RESTORE HEADERONLY and R
ESTORE FILELISTONLY to
verify the logical filenames etc, and based on that construct your RESTORE c
ommand.
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.
>--
>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[vbcol=seagreen]
>
>.
>|||I see. I'm afraid that we can't be of much help here if you don't post the o
utput from these
statements and the exact restore command you try to execute. Basically, we d
on't have anything to go
on.
You might want to open a case with MS support if you feel that you have cons
tructed 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
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
CheersCan 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...
>> 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
>
>.
>|||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...
> 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...
> >> 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
> >
> >
> >.
> >|||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.
>--
>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...
>> 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...
>> >> 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
>> >
>> >
>> >.
>> >
>
>.
>|||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...
> 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.
> >
> >--
> >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...
> >> 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...
> >> >> 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
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||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...
> 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...
> >> 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
> >
> >
> >.
> >|||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
>--Original Message--
>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...
>> 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.
>> >
>> >--
>> >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...
>> >> 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...
>> >> >> 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
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>|||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...
> 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
> >--Original Message--
> >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...
> >> 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.
> >> >
> >> >--
> >> >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...
> >> >> 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...
> >> >> >> 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
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >
and ame getting this error message
'Logical file x is not part of database x'
can any one explain
CheersCan 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...
>> 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
>
>.
>|||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...
> 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...
> >> 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
> >
> >
> >.
> >|||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.
>--
>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...
>> 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...
>> >> 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
>> >
>> >
>> >.
>> >
>
>.
>|||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...
> 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.
> >
> >--
> >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...
> >> 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...
> >> >> 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
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||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...
> 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...
> >> 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
> >
> >
> >.
> >|||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
>--Original Message--
>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...
>> 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.
>> >
>> >--
>> >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...
>> >> 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...
>> >> >> 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
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>|||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...
> 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
> >--Original Message--
> >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...
> >> 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.
> >> >
> >> >--
> >> >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...
> >> >> 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...
> >> >> >> 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
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >
Wednesday, March 7, 2012
restore a sql server 6.5 db to sql server 2000
for disastor recovery purposes i have a user request to restore a sql server 6.5 base backup(.dat file) into sql server 7.0 or 2000. can this be done in a restore on a different server?? all servers are windows 2000Simple answer is NO.
http://www.mssqlcity.com/FAQ/BackRest/Res65Back.htm
But try this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx#EQFAC|||where can i find this upgrade wizard in sql 2000??|||Information is all in the same page.
Note: To run the SQL Server Upgrade Wizard, you must have an instance of SQL Server 2000 already installed on your computer.
1. On the Start menu, point to Programs/Microsoft SQL Server-Switch, click SQL Server Upgrade Wizard, and then click Next.
2. Select Named pipe; then click Next.
3. In Export server (6.5), in the Server name box, enter the name of the local or remote computer on which SQL Server 6.5 resides.
4. In the Administrator password ('sa') box, enter the sa password for SQL Server 6.5, and then click Next.
Note: Unless you have changed it, the system administrator (sa) password for SQL Server 2000 is blank.
5. Include the databases to upgrade. Move any database not to include in the disk space estimation to the Exclude list, and then click Next.
6. Select Use the default configuration or edit the default; then click Edit.
The SQL Server Upgrade Wizard layout utility appears, showing the proposed layout of the SQL Server 2000 data files.
7. Click Advanced.
8. Click an object in the Proposed database layout box to view details in the Object details box.
9. The Drive summary box shows the estimated size of all SQL Server 2000 data files and the free disk space left on all of the local fixed disks. On the Options menu, select Freespace includes 6.5 files to view the free space that would exist if the SQL Server 6.5 data files were deleted.
10. Click Accept to return to the Database Creation dialog box.
11. Click Cancel to quit the SQL Server Upgrade Wizard.
http://www.mssqlcity.com/FAQ/BackRest/Res65Back.htm
But try this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx#EQFAC|||where can i find this upgrade wizard in sql 2000??|||Information is all in the same page.
Note: To run the SQL Server Upgrade Wizard, you must have an instance of SQL Server 2000 already installed on your computer.
1. On the Start menu, point to Programs/Microsoft SQL Server-Switch, click SQL Server Upgrade Wizard, and then click Next.
2. Select Named pipe; then click Next.
3. In Export server (6.5), in the Server name box, enter the name of the local or remote computer on which SQL Server 6.5 resides.
4. In the Administrator password ('sa') box, enter the sa password for SQL Server 6.5, and then click Next.
Note: Unless you have changed it, the system administrator (sa) password for SQL Server 2000 is blank.
5. Include the databases to upgrade. Move any database not to include in the disk space estimation to the Exclude list, and then click Next.
6. Select Use the default configuration or edit the default; then click Edit.
The SQL Server Upgrade Wizard layout utility appears, showing the proposed layout of the SQL Server 2000 data files.
7. Click Advanced.
8. Click an object in the Proposed database layout box to view details in the Object details box.
9. The Drive summary box shows the estimated size of all SQL Server 2000 data files and the free disk space left on all of the local fixed disks. On the Options menu, select Freespace includes 6.5 files to view the free space that would exist if the SQL Server 6.5 data files were deleted.
10. Click Accept to return to the Database Creation dialog box.
11. Click Cancel to quit the SQL Server Upgrade Wizard.
Saturday, February 25, 2012
Restore a database
Hello
Please, help me
I need to know, how to restore the database (base.bak) on MS SQL Server 2005 Ex. Ed. from my WinForm Application
I programming on C#.
Please, if you can, give me a code on C#.
Thanks
Try the following info found at http://www.csharphelp.com/archives2/archive345.html
SQL Server Backup/Restore Through SQLDMO and C#
Restore a database
Hello
Please, help me
I need to know, how to restore the database (base.bak) on MS SQL Server 2005 Ex. Ed. from my WinForm Application
I programming on C#.
Please, if you can, give me a code on C#.
Thanks
Try the following info found at http://www.csharphelp.com/archives2/archive345.html
SQL Server Backup/Restore Through SQLDMO and C#
Subscribe to:
Posts (Atom)