cookiemonstagt (5/3/2016)
Lynn Pettis (5/3/2016)
cookiemonstagt (5/3/2016)
So why they need to bk up those files?They are system databases required by SQL Server to run correctly. Without them you have no server.
So when the shared files are updated also the local will be updated at the
same time ..?
There are no local files.
There is a single copy of each of these databases' files (6 minimum) on shared storage (since this is a cluster). They're essential for SQL Server to run, and hence they MUST be backed up. However a copy-paste is not a backup and is not what should be done. The DBA should be backing these up regularly as part of his regular scheduled database backups.
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