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.