Post reply

SQL Policy failing for no apparent reason!?

  • December 22, 2014 at 4:07 am

    #397799

    Hi, I have the 'data and backup location on separate drives' policy failing on just one server, although there are no .bak or .trn files on the drive where there are data files for that DB. Also another DB that has it's files on the same partition, is not failing!?! Ideally I want to see the code for the expression to see exactly what it's trying to compare. Failing that has anyone had a similar problem? Is it testing for more then just .bak and .trn?

    thanks very much

  • December 22, 2014 at 4:52 am

    #1765949

    simon.letts (12/22/2014)

    Hi, I have the 'data and backup location on separate drives' policy failing on just one server, although there are no .bak or .trn files on the drive where there are data files for that DB. Also another DB that has it's files on the same partition, is not failing!?!

    Doesn't that policy just check the default locations for data files and backups, not the actual locations where things are?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 22, 2014 at 5:19 am

    #1765956

    Hi, no it doesn't. It checks at least for .bak and .trn files being on the same drive as .mdf etc. But I'm not 100% sure of the code and wanted to know precsiely how it works. For this server the defaults are E: for data and D: for backups.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply