andrewkane17 (1/25/2010)
isn't this a point of failure that cannot be easily be remedied whenever the mssqlsystemresource.mdf and mssqlsystemresource.ldf ever become corrupt?
Yes, but since those only change when service packs/hotfixes are installed, you can just stop SQL as part of the SP installation and take file backups of them.
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