We have an MDM 7.1 SP 12 system installed on SQL 2008.
We wish to backup the system so that in case of a crash a DB restore should suffice...
We don't use the Archive/Unarchive method for repo backups.
Thus, as a backup strategy:
1. Do we need to schedule each repository's DB/Log backup using the Management Studio (this would also keep the log growth in check ?)
2. Is there an easier way to go about this...since each repository makes 2 DB's.....
Please help advise...
Thanks a lot !