my 2 cents...

To answer your question about Simple and Full recovery model, I would say that it depends on business requirements. If your are looking for point in time recovery...

If you can maintain same directory structure as in old server then it should be more easy than backup and restore.

1. Install SQL Server on New Machine and bring it...

what is the exact error message?

Do a Ctrl+C on message window and paste in next post. This will help us better to find cause/possible solution

It will log message in Event Log (or you can specify text file during wizard) This will help you drill down the issue while using Copy database wizard.

Do you have...

No sure whats going on with your server.

Few things which i would like to check

1. Do you have Lock Pages in Memory enabled for SQL Server?

2. When you are...

1. try

select * from [PSM_BOOKING_REPORTS_DM_temp_03]

2. I am suspecting space after/befor the table name.

3. Run DBCC CHECKTABLE (PSM_BOOKING_REPORTS_DM_temp_03) to check corruption in the table

I always look into SQL ErrorLog to find the port on which my SQL Server is listening.

you can use sp_readerrorlog procedure to read errorlogs from query analyzer.

This should exist in...

please conact me offline at bmlakhani@yahoo.com

I would like to see .mdmp file generated by this Access Violation

Do you see any dump (.mdmp or .dmp) files being generated under LOG folder? please contact me offline at bmlakhani@yahoo.com

I think you should apply SP1 on database engine...

Do you have Visual Studio 2005 installed on same box?

can you please try below from command prompt

telnet TOP-DB05.array.com 5023

Above is to check if port is open

Are you able to connect to SQL Server from Local machine using windows authentication?

Do you have any certificates installed on this machine?

As far as I know, there should be no issues.

Only thing I am aware of is that you cannot install another SQL 2000 after installing SQL 2005 instance. I remember...

SQL 2005 CD comes with licence.

As far as I know, in SQL 2005 there is no place you can add licences later. This is more liks paper licence. You need...

First think I would ask is that how many instances you have on the server where you are trying to install SP1?

If i understand correctly, most of components are already...