Shulou(Shulou.com)06/01 Report--

First, back up the database

1, click "manage"-"maintenance Plan", right-click "New Task Plan"

2. Set the automatic execution time of the backup plan according to your own needs. Here, I set the backup plan to be executed at 12 am every day.

3. Add a backup database plan

4. Set options related to the backup database plan

5. After the backup plan is completed, you can perform a full backup immediately.

Second, restore the database

1, right-click the database you want to restore, and then click "Task-restore-Database".

2, choose to restore the latest backup set in the source database, or find the backup set you want to restore in the system file path on the source device.

Error handling may occur when restoring database files:

When restoring the database, click the option on the selection page, check the overwrite existing database (WITH REPLACE), and click OK to restore the database successfully.

Complete the restore:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.