• Andy,

    thanks. yes it is pretty dumb, especially as SQL2000 could handle any requirements fine. I will have to layout my backups and maintenance plans to work around this foible, though hopefully MS will fix this in the future.

    I put it down to using SSIS for maintenance plans, which I have never liked.

    ---------------------------------------------------------------------