The Assignment
Use database backup and restore to recover lost data
Database Maintenance and Lab Skills
Database Maintenance
This is the last database implementation. You can take your time to correct the errors of your lab 6 impmentation provided in the feedback, but make sure the corrections need to be done by the due time for the lab 7 implementation:
- [req 7:00] Correct all errors (or other requested changes)
identified by your instructors in the previous Lab cycle.
Lab Skills
- Use SSMS GUI to backup and restore data
Analyst Notes & Deliverables Details
NOTE: Create a single .sql file named as Lab7_YOUR_TEAM_NAME.sql. Record in the file all the DML statements for this assignment.
Preceed each SQL statement with a brief comment describing what that SQL statement is designed to accomplish
-
[req 7:30]Complete the asignment by following the instructions in this Word document: Lab 7 Implementation.
Submission:
- [req 7:40a] Submit to Canvas (L7i-DB) your most recent
Team Work Record, the SQL file: Lab7_YOUR_TEAM_NAME.sql, and the Word file.
End of Instructions
|