Shulou(Shulou.com)05/31 Report--

This article introduces the "sql database restore tutorial" related knowledge, in the actual case operation process, many people will encounter such a dilemma, and then let the editor lead you to learn how to deal with these situations! I hope you can read it carefully and be able to achieve something!

Step 1: install SQL200 and start SQL2000.

Download SQL2000 from the Internet and install it. (my operating system is XP, installed is SQL personal version), according to the picture shown below to open the SQL service manager

Click start / continue the small icon on the left to start SQL, and after refreshing the service, you can see that SQL starts.

Step 2: create a new database and restore the database

Open the Enterprise Manager for SQL, as shown in the following figure.

Expand the database, right-click the database above, create a new database, pop up the database properties dialog box, and fill in the name here with www.wangyeba.com, as shown in the following figure

Open the database file tab and copy the path in the location (from the beginning to www.wangyeba.com, do not copy later)

At this point, we can see the newly created database www.wangyeba.com. Right-click on the www.wangyeba.com database-- > all tasks-- > restore the database.

A restore database dialog box pops up, and we select from device-> disk-- > add-- > browse the backed up database file.

Confirm twice in a row, and then click "options" to copy the path we copied earlier to "move to physical path" in the option. Note that only replace the one in front of _ log and .mdf, and then start the restore.

The end interface of the restore is as follows

Step 3: add an account and password to the database

Expand the root directory of the console-- > Security, select login, right-click, we create a new login, pop up the SQL Server login box, and fill in as shown in the following figure.

Open the database access again, select the database www.wangyeba.com, select public and db_owner in the check box below, and enter the OK password after confirming.

Step 4: change the way the database is linked

Usually a conn.asp file, open it in notepad, fill in www.wangyeba.com in the database account, 111in the database password, and www.wangyeba.com in the database file name

Save exit

This is the end of the sql Database restore tutorial. Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.