We don't have a DBA and I have to do backups. We have only one database that is 3gb (the others are less than 100mb). The 3gb database is write-heavy, and has very important data. I set up daily backups for all the databases but i think that might not be enough.
- What are transactional log backups?
- what is my appropriate backup action plan for the 3gb database?
- how do i do the log backups and for what purpose?
- is a daily full backup enough?