Graphic tutorial on restoring database backup in SQL server 2000, MySQL Database Backup

Source: Internet
Author: User

Graphic tutorial on restoring database backup in SQL server 2000, MySQL Database Backup

MSSQL is a database management system of Microsoft. This document describes the backup and restoration functions of databases in MSSQL2000.

1. Ensure that your backup file is a bak file and the backup file can be restored normally.

2. Choose "Enterprise Manager"> "Database", select the database you want to restore, and right-click "all tasks"> "Restore database ".

Image and text tutorials for MSSQL2000 database backup and Restoration

3. If you need to restore a previously backed up file, select "Database" in "Restore" and select the backup to be restored below, if it is uploaded or copied from other places, select "restore from device. Click "add" to add the backup file to be restored.

Image and text tutorials for MSSQL2000 database backup and Restoration

4. Click "OK" and click "options" on the database to view the path of the recovered database. Sometimes the restoration may fail. You can select "Force restore on existing database". At this point, the database restoration process is complete.

Image and text tutorials for MSSQL2000 database backup and Restoration

5. If you already have MDF and LDF files, you can use the additional functions of the database to attach them. First, upload the mdf and ldf files of your database to a directory on the server (generally, do not place them on the system disk to avoid data loss due to system damage), such as the d: \ mssql directory, and grant full control permissions to the mssqluser directory. Open the Enterprise Manager, right-click "Database"> "all tasks"> "add Database ",

Image and text tutorials for MSSQL2000 database backup and Restoration

Click "…" Add the mdf file to be appended, and specify the Database Name and database owner to be appended.

Image and text tutorials for MSSQL2000 database backup and Restoration

Click OK to attach the database,

Image and text tutorials for MSSQL2000 database backup and Restoration

NOTE: If it is stored in another directory, make sure that the full control permission of mssqluser is added to the directory. Otherwise, the restoration or backup will fail. This permission is also required for saving the backup directory !!


How can I restore a database backed up by SQL server 2005 to 2000?

Open with 2000, and then export the SQL script
Use 2005 to open the required part of the Import

SQL Server database backup and recovery problems

Company A open the Enterprise Manager, right-click your database, and select "all tasks"-"backup database". If there is A project in "backup to", delete it, click "add", enter the name and path of the file you want to back up (you can browse and select), and click "OK". The database will be backed up (no other program will be used to open the database before backup ). The backed up file is a. BAK file.

COPY the file you specified, open the Enterprise Manager on another machine of Company B, create a database, and right-click the newly created database, select "all tasks"-"Restore database", select "Slave Device" for the restoration method, click "select device", and click "add" to find the file you copied, click "OK", click "OK", and then click "OK" to restore the database. (Check whether the path of the database to be restored exists. Otherwise, the database cannot be restored)

If you do not create a new database, but restore it to an existing database, it is best to do so before the last "OK, enable "Force restore on existing database" in "options" to avoid unnecessary problems.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.