December 22, 2014 at 4:07 am
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
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
December 22, 2014 at 5:19 am
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