SQL database restore graphics and text tutorial _mssql

Source: Internet
Author: User
First step: Install SQL200 and start SQL2000.

Download the SQL2000 online and install it. (My operating system is XP, with SQL Personal Edition), open SQL Service Manager as shown in the picture below

Start/Continue the small icon on the left to start SQL, refresh the service and you can see the SQL started.

Step Two: Create a new database and restore the database

Open the SQL Enterprise Manager, as shown in the following illustration.

Expand the database, right click on the database, create a new database, pop-up Database Properties dialog box, Name here we fill in the www.wangyeba.com, the following figure

Open the Database File tab, copy the path within the location (from the beginning to the www.wangyeba.com, and not after the copy)

This time we can see just our newly created database www.wangyeba.com , www.wangyeba.com This database right click--> All Tasks--> restore the database

A Restore Database dialog box pops up and we choose to add--> Browse backed up database files from the device--> disk-->

Determine 2 consecutive times, then start "Options", copy the path we copied earlier to the "move to physical path" in the option, and note that only replace the _log and. mdf front, and then make sure to begin the restore

The restore end interface is as follows

Step three: Add an account number and password to the database

Expand the Console root directory--> security, select Login, right-click, we create a new login, pop-up SQL Server landing box, as shown in the following figure to fill in.

Then open the database access, select Www.wangyeba.com This database, in the following check box to select public and db_owner, OK after the input to determine the password OK.

Step Fourth: Change the way the database is linked

Generally is conn.asp file, with Notepad open, in the database account that fills in the www.wangyeba.com, the database password that fills in 111, the database filename that fills in the www.wangyeba.com

Save exit

The above is the MSSQL database restore process, I wrote a detailed tutorial, but forgot to save, depressed, according to the picture to write such a simple process, we still have what do not understand can be proposed.

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.