How to Use sqlserver database to restore. bak Database Backup

Source: Internet
Author: User
Two times ago, I couldn't recover it. I 've been tossing it for a long time. This time I encountered such a problem, I forgot it, and I 've been playing it for a long time. Now I can write it down. right-click the "Database" folder under the SQLServer2008 instance. Is the directory of the same level as security and server objects. Select create database. 2. Add the Database Name, name, and backup data.

Two times ago, I couldn't recover it. I 've been tossing it for a long time. This time I encountered such a problem, I forgot it, and I 've been playing it for a long time. Now I can write it down. right-click the "Database" folder under the SQL Server 2008 instance. Is the directory of the same level as security and server objects. Select create database. 2. Add the Database Name, name, and backup data.

I couldn't recover it twice before, but it took a long time. This time I encountered such a problem, I forgot it, and it took a long time. Now I can remember it.

1. Right-click the "Database" folder under SQL Server 2008 instance. Is the directory of the same level as security and server objects. Select create database.
2. Add a database name. The name must be the same as that of the backup database. Click OK.
3. Right-click "Database", select "Restore database", select the database you just created from the target database, select the source device, select Browse, and select "add" as the backup location. Find the specified bak file and click OK. Select the imported bak file and click OK. The data is imported successfully.

If it fails, set as follows:

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.