Friday, February 24, 2012

Microsoft SQL-DMO

I got an error as following while I am trying to restore a database:
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
>> I got an error as following while I am trying to restore a database:
>> Microsoft SQL-DMO (ODBC SQLState:42000)
>> Device activation error: The physical file name ... may be incorrect.
>>
>> Please help how to solve this problem. Thanks.|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > Allen,
> >
> > Check your spelling of the file name you are trying to restore from. They
> > do not match.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602m.html
> >
> >
> > "Allen Iverson" wrote:
> >> I got an error as following while I am trying to restore a database:
> >>
> >> Microsoft SQL-DMO (ODBC SQLState:42000)
> >>
> >> Device activation error: The physical file name ... may be incorrect.
> >>
> >>
> >> Please help how to solve this problem. Thanks.
>|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling
>> should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from.
>> > They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>> Note that the restore is performed on the server. Are you sitting on the server when you use
>> explorer to get the file name?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> ""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from. They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>>
>

No comments:

Post a Comment