No, You were not alone. I had the same thoughts

Regards Ib

Hi

I have succesfully moved from an old server to a new server several times. Nothing fancy in those servers though.

Installing the new server, applying SQL Server, SP3a.

Stopping SQL on...

It is commonly known that the MMC console is unreliable.

I have experienced several occasions where I have to close the EM/MMC console and open it again before primarily deletions...

To my knowledge you miss that above 16Gb of Memory you must use /3gb

so:

below 3Gb : nothing

more than 3Gb : /3gb

More than 4Gb and less than 16Gb: /3Gb and /PAE

More...

Sql Server 2000 Standard edition is limited to 2Gb Memory on any OS

Look at  http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp

Try look at BCP (Bulk Copying Program) to move the data between the servers.

Hmm to my knowledge it is neccesary to set the /3GB in boot.ini in order to use memory above 3Gb.

Search for /3Gb and /PAE

I havent checked it out. And as it is removable I have no interest in it either.

I would still backup to disc, and then copy this backup to a backup...

First of all I dont understand why You do it this way. Let SQL Server make a backup to disc, which You can copy to tape, and then exclude *.LDF,...

Have You tried to get an RDP connection to the server instead, and using the necessesary tools remote?

Regads Ib

Well I started the thread today and Grasshoppers posting was satisfaying, and I do now see the difference in the semantics.

So the correct answer IS the correct answer. DAMN!

Regards...

Hi

English aint my first language, so what is the real difference between the two answers:

Correct Answer:

You cannot do this as the update references two tables.

You Answered:

You...