SIMS: Backup and Recovery
I was curious about what others do for backup and recovery of SIMS.
We use DPM 2010, and I have no experience of SQL Server restores. At the moment DPM is set to backup SQL instances daily at 2am.
Within the SQL instances there are several databases: model, master, Discover, msdb and SIMS. Is restoring the database as simple as just recovering the SIMS database from the list?
Do others backup more frequently? (I'm guessing that DPM takes a shadow copy of the database, with respect to backing up a working database)
Any information on this gratefully received.