SQL Server 2000 database Restore Instance Operations tutorial

SQL Server is a http://www.aliyun.com/zixun/aggregation/22.html "> relational database management system it was originally created by Microsoft Sybase And ashton-tate three companies developed in 1988 launched the first powering version of Microsoft and Sybase in the development of SQL Server after the introduction of Windows NT Microsoft will SQL Server Migrate to Windows NT systems focus on developing a Windows NT version of SQL Server. Sybase is more focused on SQL Server applications on UNIX operating systems in this book, Microsoft SQL Server is referred to as SQL Server or MS SQL Server.
SQL Server 2000 is the latest version of a Microsoft company's SQL Server database management system that inherits SQL Server 7.0 The advantage of the version is that it adds many more advanced features with the advantage of ease of use and scalability, and the high degree of integration with related software can span from a laptop running Microsoft Windows 98 to running Microsoft Windows 2000 Large multiprocessor servers and many other platforms.

There are 4 versions of SQL Server 2000, individual, Standard, enterprise, and development.

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