Four ways to back up your database:
L Full Backup: Creates a copy of the data that exists in the database when the backup is complete.
differential backup: Records only data that has changed since the last database backup. Differential database backups are smaller than database backups, and backups are faster, so you can back up more often, and regular backups reduce the risk of losing data.
log backup: is a series of records of all transactions performed on the database since the last backup of the transaction log. You can use transaction log backups to restore a database to a specific point in time, such as before you enter excess data, or to recover to a point of failure.
L Filegroup Backup: You can back up and restore individual files in the database. You can restore only corrupted files without restoring the rest of the database, which speeds up recovery.
Software Functional Requirements Analysis:
Software requirements include three different tiers: business requirements, user requirements, and functional requirements (including non-functional requirements). As a software requirement analyst, it is necessary to separate these three levels.
1. Business requirements (businessrequirement) reflect organizational or customer requirements for high-level systems and products, in other words, the business needs generally describe why the system is being developed (why) and what the organization wants to achieve.
2. The user requirements (userrequirement) document describes the tasks that the user must complete to work with the product, as described in the use cases document or scenario script description. In other words, user requirements must be able to reflect the business value that the software system will bring to the user, describing what the user can do with the system.
3. Functional requirements (functionalrequirement) define the software capabilities that developers must implement to enable users to fulfill their tasks and meet their business needs. That is, how developers design specific solutions to implement these requirements.