SQL Server 2000 database Restore Instance Operations tutorial

Source: Internet
Author: User
Keywords nbsp running operating system installing

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

  

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.