MSSQL Database restore graphics and text tutorial

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Some netizens asked how to debug the MSSQL database program, began to simply say, but the fear that we do not understand, or did a picture version of the description, I hope we can understand.

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 domain name, the following figure

Open the Database File tab, copy the path inside the location (copy from the beginning to the domain name, and do not copy after)

This time we can see just our newly created database, on this new 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 just the new 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 database name, the database password that fills in 111, database filename that fills in the database name, saves exits

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.