Device Activation Error

Dear All,
I have deployed a new SQL server and I have installed SP4, I have tried to
restore my old dbase using restore from device and I choosed the dbase file
name. I got the following error (Device activiation error. The physical name
'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
location for the file.
Please helpppp
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> Dear All,
> I have deployed a new SQL server and I have installed SP4, I have tried to
> restore my old dbase using restore from device and I choosed the dbase
> file
> name. I got the following error (Device activiation error. The physical
> name
> 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> location for the file.
> Please helpppp
This means that one or more of the files the database is being restored to
already exists. Check the file name. If a file exists there, you might
want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
David
|||Hi David,
The files aren't there and I even tried to renave the dbase and the log file
but it didn't work. USE WITH MOVE it was in the warning message and I can't
find it at all in the restore options.
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"David Browne" wrote:

> "Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
>
> This means that one or more of the files the database is being restored to
> already exists. Check the file name. If a file exists there, you might
> want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
> David
>
>
|||> USE WITH MOVE it was in the warning message and I can't
> find it at all in the restore options.
Below is a Transact-SQL example of the MOVE option David suggested. The
drives/folders must exist but the file must not.
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH
MOVE 'MyDatabase' TO 'E:\DataFiles\\MyDatabase.mdf',
MOVE 'MyDatabase_Log' TO 'F:\LogFiles\\MyDatabase_Log.ldf'
You can list the logical file names needed for the MOVE option with RESTORE
FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
Hope this helps.
Dan Guzman
SQL Server MVP
"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0B29F43E-C8ED-4B4B-B93E-5F85EE0DBF6A@.microsoft.com...[vbcol=seagreen]
> Hi David,
> The files aren't there and I even tried to renave the dbase and the log
> file
> but it didn't work. USE WITH MOVE it was in the warning message and I
> can't
> find it at all in the restore options.
> --
> *********
> IT Manager
> DeLaval Ltd.
> Cairo-Egypt
> *********
> |--|
> |Islam is peace not Terror|
> |--|
>
> "David Browne" wrote:

Device Activation Error

Dear All,
I have deployed a new SQL server and I have installed SP4, I have tried to
restore my old dbase using restore from device and I choosed the dbase file
name. I got the following error (Device activiation error. The physical name
'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
location for the file.
Please helpppp
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> Dear All,
> I have deployed a new SQL server and I have installed SP4, I have tried to
> restore my old dbase using restore from device and I choosed the dbase
> file
> name. I got the following error (Device activiation error. The physical
> name
> 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> location for the file.
> Please helpppp
This means that one or more of the files the database is being restored to
already exists. Check the file name. If a file exists there, you might
want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
David|||Hi David,
The files aren't there and I even tried to renave the dbase and the log file
but it didn't work. USE WITH MOVE it was in the warning message and I can't
find it at all in the restore options.
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"David Browne" wrote:
> "Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> > Dear All,
> >
> > I have deployed a new SQL server and I have installed SP4, I have tried to
> > restore my old dbase using restore from device and I choosed the dbase
> > file
> > name. I got the following error (Device activiation error. The physical
> > name
> > 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> > location for the file.
> >
> > Please helpppp
>
> This means that one or more of the files the database is being restored to
> already exists. Check the file name. If a file exists there, you might
> want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
> David
>
>|||> USE WITH MOVE it was in the warning message and I can't
> find it at all in the restore options.
Below is a Transact-SQL example of the MOVE option David suggested. The
drives/folders must exist but the file must not.
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH
MOVE 'MyDatabase' TO 'E:\DataFiles\\MyDatabase.mdf',
MOVE 'MyDatabase_Log' TO 'F:\LogFiles\\MyDatabase_Log.ldf'
You can list the logical file names needed for the MOVE option with RESTORE
FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0B29F43E-C8ED-4B4B-B93E-5F85EE0DBF6A@.microsoft.com...
> Hi David,
> The files aren't there and I even tried to renave the dbase and the log
> file
> but it didn't work. USE WITH MOVE it was in the warning message and I
> can't
> find it at all in the restore options.
> --
> *********
> IT Manager
> DeLaval Ltd.
> Cairo-Egypt
> *********
> |--|
> |Islam is peace not Terror|
> |--|
>
> "David Browne" wrote:
>> "Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
>> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
>> > Dear All,
>> >
>> > I have deployed a new SQL server and I have installed SP4, I have tried
>> > to
>> > restore my old dbase using restore from device and I choosed the dbase
>> > file
>> > name. I got the following error (Device activiation error. The physical
>> > name
>> > 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a
>> > valid
>> > location for the file.
>> >
>> > Please helpppp
>>
>> This means that one or more of the files the database is being restored
>> to
>> already exists. Check the file name. If a file exists there, you might
>> want to rename it. Or, as the message indicates, use RESTORE ... WITH
>> MOVE.
>> David
>>

Device Activation Error

Dear All,
I have deployed a new SQL server and I have installed SP4, I have tried to
restore my old dbase using restore from device and I choosed the dbase file
name. I got the following error (Device activiation error. The physical name
'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
location for the file.
Please helpppp
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|"Ibrahim Awwad" < ibrahim_awwad(at)hotmail(dot)com(antispa
m)> wrote in
message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> Dear All,
> I have deployed a new SQL server and I have installed SP4, I have tried to
> restore my old dbase using restore from device and I choosed the dbase
> file
> name. I got the following error (Device activiation error. The physical
> name
> 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> location for the file.
> Please helpppp
This means that one or more of the files the database is being restored to
already exists. Check the file name. If a file exists there, you might
want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
David|||Hi David,
The files aren't there and I even tried to renave the dbase and the log file
but it didn't work. USE WITH MOVE it was in the warning message and I can't
find it at all in the restore options.
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"David Browne" wrote:

> "Ibrahim Awwad" < ibrahim_awwad(at)hotmail(dot)com(antispa
m)> wrote in
> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
>
> This means that one or more of the files the database is being restored to
> already exists. Check the file name. If a file exists there, you might
> want to rename it. Or, as the message indicates, use RESTORE ... WITH MOV
E.
> David
>
>|||> USE WITH MOVE it was in the warning message and I can't
> find it at all in the restore options.
Below is a Transact-SQL example of the MOVE option David suggested. The
drives/folders must exist but the file must not.
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH
MOVE 'MyDatabase' TO 'E:\DataFiles\\MyDatabase.mdf',
MOVE 'MyDatabase_Log' TO 'F:\LogFiles\\MyDatabase_Log.ldf'
You can list the logical file names needed for the MOVE option with RESTORE
FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
Hope this helps.
Dan Guzman
SQL Server MVP
"Ibrahim Awwad" < ibrahim_awwad(at)hotmail(dot)com(antispa
m)> wrote in
message news:0B29F43E-C8ED-4B4B-B93E-5F85EE0DBF6A@.microsoft.com...[vbcol=seagreen]
> Hi David,
> The files aren't there and I even tried to renave the dbase and the log
> file
> but it didn't work. USE WITH MOVE it was in the warning message and I
> can't
> find it at all in the restore options.
> --
> *********
> IT Manager
> DeLaval Ltd.
> Cairo-Egypt
> *********
> |--|
> |Islam is peace not Terror|
> |--|
>
> "David Browne" wrote:
>

Developer Edition vs Enterprise Edition

Does anyone know why the same cube
deployed on 2 different servers (one Enterprise Edition,
the other a Developer Edtion) with the same MDX
query would return 2 different Results?

MDX query I am using:

WITH MEMBER [Measures].[TimeChargedToDate] AS
'SUM({NULL:[Timesheet].[Date].&[2006].&[9].&[15]},[Time Charged])'

SELECT NON EMPTY
{
[Measures].[Time Charged],
[Measures].[TimeChargedToDate]
} ON COLUMNS,
NON EMPTY
{
(
[Project].[Project Number].&[Z07600] *
[Staff Member].[Staff Member Name].[Staff Member Name].ALLMEMBERS
)
} ON ROWS
FROM
(
SELECT
{[Timesheet].[Date].[Year].&[2006].&[9].&[2] : [Timesheet].[Date].[Year].&[2006].&[9].&[15]}
ON COLUMNS
FROM
(
SELECT ( [Project].[Project Number].&[Z07600] ) ON COLUMNS
FROM [Timesheet_Cube]
)
)

On the Enterprise Edition my results are:
Time Charged TimeChargedToDate
Z07600 Person One (null) 0.25
Z07600 Person Two (null) 2
Z07600 Person Three (null) 1
Z07600 Person Four 82 276
Z07600 Person Five 69.5 307.75
Z07600 Person Six (null) 187.25
Z07600 Person Seven (null) 24.5
Z07600 Person Eight (null) 77.5
Z07600 Person Nine 34 34

On the Developer Edition My results are:
Time Charged TimeChargedToDate
Z07600 Person Four 82 82
Z07600 Person Five 69.5 69.5
Z07600 Person Nine 34 34

Same query, same cube, same data (I backed up the processed cube
from the developer edition and restored it on the Enterprise Edition to
make sure that I did not reProcess the cube and have that affect something)
and somehow I get different results.

Any ideas as to why this is happening?

Hello. We can test this more rapidly if you can repeat this using the Adventure works cube and an MDX-example with that cube.

Are the service packs or hotfixes different on these servers? What tool do you use to query the cubes?

Regards

Thomas Ivarsson

|||

Nothing special has been done with the servers.
They are both 2005 servers and I am using Management
Studio as my MDX query tool.

I can try to reproduce this with adventureworks... It will
take some time.

|||

Are both servers sp1 servers. Do one or both have the same hotfixes after sp1?

Do you use the same partions on both servers(one or several?)

Regards

Thomas Ivarsson

|||

I cannot reproduce the problem with
AdventureWorks using MS sample UDM.

|||

It appears that my local machine
may not have SP1 installed. I will
give that a shot then try again.

Thanks.

|||

After installing SP1 on the Developer Edition,
this problem goes away... How interesting.

Thanks for you comments everyone!