That'll teach me to read the rest of the query rather than just jumping in with both feet

As mjschwenger (odd name

Have you tried rewriting the query to use a join rather than doing it via your current method? SQL will evaluate the new script differently to your current one.

Something like...

it depends a lot on the server and disk subsystem too, is the mdf on a raid 5 set?

Congratualtions Frank, you really deserve it

Maybe one day the rest of us will be as clued up as you but for us lesser...

No ideas (sorry) but please keep us posted as to what MS come back with

How big is the database that you're backing up?

If it's around the 5GB mark but has very little data in it that would explain why the restore is taking so...

I've remember seeing this in SQL 7 from time to time, basically it's telling you that it thinks the default filegroup is full (the data file).  This sometimes happened (albeit...

couldn't have explained it any better than that (although I could definately have done a much worse job if you'd have prefered )

definately a mistype

/3GB

no problem

You can safely use SQL Enterprise Edition with 4GB; standard was capped at 2GB nomatter what you did. the /3G switch just...

Not a problem I've ever seen before but in general performance counters normally are unavailable when the perfmon service starts before the SQL instance.

If you have more than one sql...

Sounds like you just need to attach the database.

From Enterprise Manager

• Right click on databases, select all tasks and then attach database.
• Browse to the location that you copied the files...

It sounds as if the backup to the floppy disk (didn't know anyone still used these ) was done directly rather than to...

It shouldn't be too much of a problem to schedule a backup to a  predefined folder (ask whoever is doing the hosting to tell you where to put it).

If you...

From what I can see you're not doing anything that will cause you problems.

In order to use the extra memory (over 2GB) with sql you're have to add the /3G...