If you are backing up to a file device using append or overwrite -

Delete or preferably, rename, your old backup file and try again. If the backup works immediately discard the...

Damn those checkboxes !

Or you can do SAVE AS and pick the other server.

OK for a few packages at a a time.

DB

Ahem,

"Check that the area the backup file is going to allows the create/write operation. (And has sufficient space)

***** Check that the database recovery mode is "Full"

What db work was...

Check that the area the backup file is going to allows the create/write operation. (And has sufficient space)

Check that the database recovery mode is "Full"

What db work was done ?

DB

DB Backup file comes in at around 2.5 gig. Network Connectivity appears fine.

I suspect something else other than connectivity issues as the job fails at the same point (as it...

Used to do that - ran out of room. And occasionally the jobs were not automatically deleted.

Thanks,

DB

I use UtraEdit32 (not just for this) and it prints in colour - and you can set the colours easily enough. It has language templates for lotsa things.

Good for huge...

According to MSoft you can't uninstall MDAC components (they've obviously never heard of the delete key)

But it can be useful to have the old ones hanging around for programs that...

Well David, if you go to a machine that has similar or the same drivers and export the ODBCINST reg entry from HKLM/SOFTWARE/ODBC, and then import that into your broken...

It's about to be vaporised, like the dinosaurs and the meteor - if you subscibe to that theory.

No other reason.

DB

Brill !

Got it in one - sp returns 65, which makes sense as it is a dinosaur database.

thanks,

DB

This is more a case of sloppy coding by Microsoft - there is no mention of this aberrant behaviour of GOTO's and labels in BOL or Technet/KBase etc. This is...

And if the 'empty' columns are actually 'Null' check out 'is null' or function IsNull in BOL.

What Service Pack is SQL Server at ?