Backing up the database is important in case of system or hardware failure (or user errors) that cause the database to be damaged in some way, thus requiring a backed-up copy to be restored.
To create a database backup task, you should create a maintenance plan
Review the steps in the following link
https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/use-the-maintenance-plan-wizard?view=sql-server-ver15
Using the SQL Server on your local machines (csserver cannot be use)
What to Submit
1. A Word document with screenshots of the database plan added to the Management folder in the SQL Object Explorer
2. The SQL files you used
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here