there are still many more SQL 2000 instances out there than 2005, so most people would answer this based on their 2000 experience. So the correct answer is a)

point back...

A good thing to have would be a performance baseline taken under 'normal' conditions to compare performance against when these large processes are running. This would be i/o, cpu ,disk...

no probs, thanks for replying. I've downloaded procmon and will have a play next week.

oh, I read that as he'd tried both.........that never ocurred to me!

hmm, I dont think this works quite as you are expecting. I'm presuming a small company here with one server, small amount of data?

In management studio create a maintenance plan...

If you have tried to back up the database via a maintenance plan there must be an agent job. What does the 'view job history' say happened. does the job...

cheers, I am havng trouble seeing where it shows i/o per file from the gumph but I'll give it a go and report back...............

anyone? is it not possible?

not quite sure why or what you want to copy to a hard disk and why you need to do from the command line, but SQL does come with a...

we are going to need more info than that to be able to help you. Whats the error message?

common cause for maint plan job not working is SQL not recognizing...

Matt, thanks. I am sure the extra info on licensing will be useful to david though (don't know where I got paul from, sorry david). If he goes active\active he...

Matt, Pauls question was could he use standard edition in a two node cluster or would he have to use enterprise edition. The answer is yes he can use standard...

you are missing a comma at the end of the first with move line i.e.

WITH MOVE 'MyDatabase' TO...

Action plan:

Attached new SAN drives to old server. (Infra Team)

Detached DBs and copied DB files to new SAN drives. (DBA)

Move server OS to new hardware (ghost or acronis) (Infra Team)

Configure...

ALZDBA (johan?)

I was getting a syntax error so used set quoted_identifier off and the...