Hi John,

sadly not 🙁 when I moved the job across to my cluster this was already pointing at my 32bit version of DTExec.exe.

I have rebuilt the SSIS package (pointing to...

Hi John,

Please accept my apologies, I did miss the file location from the original post but I have pointed it to the version 9 32bit version of DTexec.exe.

🙂

Your help is...

Hi John,

Thanks for the reply. I have already done that as that was needed on...

Hi John,

Thanks for the reply. I have had a look at your link but I'm not sure this is the issue. I do not know much about SSIS...

Hi Gianluca,

thanks for the post it has pointed me in the right direction.:-) I have amended the code slightly to fit in with the rest of my script.

Many Thanks

Sorry Gethin you are totally right.

I was only trying to be helpful by giving another DBA (and others that read these forums) something for consideration. I think it is...

A word of warning about running SQL on VMWare. I have been speaking to a SQL DBA who has been working for a large UK bank who has run...

Hi Gethyn,

We run Checkdb within another action plan and if problems are reported we look at the database then.

I think you may be missing the point I am trying...

You may run into trouble but surely it would be better to have something to try and restore (corrupt or not) rather than nothing?

Grasshopper :

Surely if your Database is corrupt it is all the more reason to back it up? At least if you have a backup you have something to restore and...

jasona.work

Just something to think about. Consider seperating out a database backup maintenance plan. If the plan fails you may end up with no backups at all! :crazy: If you...

Yes, We store 2 days SQL backups locally but also copy these backups on to our 3rd party corporate backup system.

I usually perform the clean up before the backups, that way, it will make the most efficient use of disk space and backups are less likely to fail due to...