SQL database restoration graphic tutorial

Some netizens asked how to debug the MSSQL database program and started to explain it briefly. However, I am afraid that you may not understand it. I still gave a picture description. I hope you can understand it.

Some netizens asked how to debug the MSSQL database program and started to explain it briefly. However, I am afraid that you may not understand it. I still gave a picture description. I hope you can understand it.

Step 1: Install SQL200 and start SQL2000.

Download SQL2000 from the Internet and install it. (My operating system is XP and I installed the SQL Personal Edition). Open the SQL Service Manager as shown in the following figure.

Click Start/continue the small icon on the left to start the SQL statement. After refreshing the service, you can see that the SQL statement is started.

Step 2: Create a new database and restore the database

Open the SQL Enterprise Manager, such.

Expand the database, right-click the database, and create a new database. The database Properties dialog box is displayed. Enter www.wangyeba.com as the name, as shown in figure

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

Now we can see the newly created database www.wangyeba.com. Right-click the database www.wangyeba.com and choose all tasks> Restore database.

A "Restore database" dialog box is displayed. Choose "device"> "disk"> "add"> "Browse" the backup database file.

Determine twice in a row, and then enable "option" to copy the copied path to "move to physical path" in the option. Note that only _ log and. before mdf, and then confirm to begin Restoration

The restore end interface 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, and create a new login. the SQL Server logon box is displayed, as shown in.

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

Step 4: Change the database connection method

It is usually a conn. asp file. Open it in Notepad. Fill in www.wangyeba.com in the database account, fill in 111 in the database password, and fill in www.wangyeba.com in the database file name.

Save and exit

The above is the restoration process of the MSSQL database. I wrote a detailed tutorial, but I forgot to save it. I was depressed and wrote this simple process based on the image, if you have any questions, you can raise them.