The SQL Server backup and restore component provides an esse

The SQL Server backup and restore component provides an essential safeguard for protecting critical data stored in your SQL Server databases. Why is it vital that you back up your data and how often should you back it up. Are the SQL transaction logs important enough to back up - why or why not?

Solution

The SQL Server backup and restore component provides an essential safeguard for protecting critical data stored in your SQL Server databases.

Why is it vital that you back up your data?
It is vital to back up our data. Following are reasons why we should do this.

How often should you back up data?
Once a day is good enough. If there is very important data, doing it right away is very good.

Are the SQL transaction logs important enough to back up - why or why not?
Yes. SQL transaction logs important enough to back up. Transaction log is a crucial component of the database. Sometimes system may fails and then we need these logs to bring it to consistent state.