HanShi (7/8/2013)
mJai (7/7/2013)
I would like to have a backup of the SQL system databases (the files themselves) not the SQL backup.Why would you want a copy of the files themselves? Why does a SQL backup not satisfy your needs?.
Because it's damn handy to have copies of those files (well, master and model) in case there's any problems with the system databases. It's far easier to switch in known-to-be working files, start SQL then restore backups than to go through the hoops required to get SQL started with damaged/missing system files.
Not instead of database backups. As well as.
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