That's the wrong sequence... BACKUP FIRST... then do the rest.

make sure to advise and get approval that if anything goes wrong, no point in time recovery is available between the...

Same problem with dates!!!

You need to store all the data for the minimum safe range needed... which is often a buttload of data!

Hey Joe, don't you have an article or two posted on the subject.

It might be a good place to put a link to it!

TIA.

Not really... the check constraint error will be meaningless. You can't add a comment in the constraint but you can in the table (assuming you let the dev use...

I've used a couple ways like instead of triggers on insert and delete. The problem there is that you can only update the row (which is the design in...

I'm just curious, where did you find the required space? I'D like to know, just in case I run into the same problem.

I don't think so, I had to create indexed on my 2005 instance (now that I think of it I didn't check if the indexing changed in yukon).

Anyone care to...

That's brilliant... since the db are already offline anyways, it's not a huge step to shut down the server entirely.

Obivoulsy make sure you get a higher power to approve that...

Fool around with the settings, I'm sure it's possible to play with that in the text mode however I have never done that.

More to the point I was off on...

That's the recommended approach, however he can't even get that far!

AFAIK, paradox is a fancy name for a csv. Have you tried linking to it as a text file and see what happens then?

There shouldn't be any need for...

Might be normal (not sure).

Try putting the backup file on a different disk set than the drives where you restore to and see how much faster it is...

I'd expect the...

Another option is delete all the files in this folder :

C:\WINDOWS\Prefetch

Also

C:\WINDOWS\Downloaded Program Files

Checkout this application, it has a great disk cleaner, maybe it can give you just enough spare place to connect :

http://www.auslogics.com/en/software/boost-speed/download

Another extreme solution I have found is to go...

And here, the thread died, a horrible, messy Gassy death.