yes i kno mcse is certification...

so it is job of system engineer who has administrator rights

thanks 🙂

thanks for the reply.

who will look after the SPN issue? DB admin or MCSE?

C:\> nslookup 192.168.0.xx

prompts follwoing message

cannot find server name for adress 192.168.0.yy: (which is address of primary domain) non-existent server

server: unknown

ip adress: 192.168.0.yy

cannot find server 192.168.0.xx non-exesitent server

Please note - cannot...

i can ping to A0002 by name as well by ip address.

New PC is having the same ip.

Old PC has been given diff ip and diff name.

Thank you for the replies and information....:)....i may come back after reading the article and if i cannot trace 1024.....

Job history is showing follwoing details...

Executed as user: NT AUTHORITY\SYSTEM. Transaction (Process ID 220) was deadlocked on lock resources with another process and has been chosen as the deadlock victim....

thanks for the reply 🙂

I found the following info regarding AWE...

If the total available memory is less than 3 GB, the instance of SQL Server 2000 will be started in non-AWE mode even if...

I totally agree with you with context to 2GB memory.

i am not trying to configure AWE. my question is 'is AWE is enabled by default?' or it has to be...

Thank you very much for your help...

currently i managed to get MDF and LDF file from the original server and attached database on my server... it is working..

But i would...

--- command

Restore filelistonly

from disk = 'D:\Dr. Acharya\ManCanDoSql.bak'

--- result

Mancandosql_DataC:\MSSQL7\data\Mancandosql.mdf

Mancandosql_LogC:\MSSQL7\data\Mancandosql_Log.LDF

---- command

Restore Database ManCanDoSql

from Disk = 'D:\Dr. Acharya\ManCanDoSql.bak'

with move 'Mancandosql_Data'to 'D:\ManCanDo-Data\Mancandosql_Data.Mdf',

move 'Mancandosql_log' to 'D:\ManCanDo-Data\Mancandosql_Log.Ldf',

Recovery

---- result

Server: Msg 3154, Level...

Restore Database

from disk = 'D:\Dr. Acharya\ManCanDoSql.bak'

I also tried the above command with 'with replace'

I m trying to restore back up of sql 7 in sql 2000.

I get following error when i try with query analyzer:

'It is not recognized resotre option'

what does this mean?

When...