How to create a local SQL database

sql2000

In the start-program-microsoftsqlserver-enterprise manager interface, open the console root file and record all the numbers to (local) (windowsnt), which has the database, data conversion service. Wait, you can right-click "New Database" in "Database" and you're done.

sql2005

Open sqlservermanagementstudio.

In the "Connect to Server" dialog box, select "Database Engine" for the "Server Type" drop-down option, and the "Server Name" degree will display the last connected server by default, and you can use the computer name, IP address, or named Guan Feng to connect.

Open Object Explorer and right-click Databases to create a new database.

After clicking New Database, a window will appear, usually as long as you have completed the normal page setup. The settings are as follows:

1 The "database name" should conform to the SQL naming convention, and should not be the same as the existing database name. 2 "Owner", click ". button to choose another user.

3 "Use full-text indexing", which can be indexed quickly and elastically, and is more efficient than like expressions when querying large amounts of unstructured text data.

4. "Logical name", which is generally the default one, is easy to manage.

5 "Initial size", set to how large you can use according to your main database, set to a few sizes, and then set to enable "Autogrow". Generally, press 1M, "no limit to file growth".

6 Path, select the location where the database is stored.

7 The settings of the log are the same as the data setting technique, but it should be noted that the log file will record all changes and updates that occur in the database, so that in the event of various accidents such as hardware damage, the data can be effectively restored to the point in time when the accident occurred, so as to ensure the consistency and integrity of the data. Obviously, in order for a log file to be effective, the data file must be stored on a different physical disk than the log file, which is something you need to be aware of when setting the physical file name of the log file.

8 "Add", when adding, pay attention to select "File Type", when you select Log, the filegroup will automatically select "Not applicable". Also note that the physical disks that do not use logs and storage paths should be set to be different. Clever shots for restoration.

9 If you want to create a new filegroup, select "New Filegroup" in the secondary data filegroup, enter a name, and select "Default". If you don't want to be modified or updated to the tables in the filegroup, you can choose "Read Only".

1. First open the sqlserver management system tool, and then use the data fan database to log in to the data management system.

2. After entering, click on the number in front of the database file, and then click on the number in front of the system database.

3. Right-click the database folder and select "New Database".

4. Then select in the pop-up interface, enter the database name, size and path.

5. Wait for the creation to complete.

6. Then refresh the traces on the left side of the database, and you can see the data file that has been successfully created.