Various management methods for SQL Server database _mssql

The scope of this article: a comprehensive description of the various operations of SQL Server database, virtual host and server two cases.

This article is relatively long, please use the outline below to access.

Outline

First, the virtual host

1. Install the online Enterprise Manager
2. Register Remote Enterprise Manager (SQL2000)
3. Register Remote Enterprise Manager (SQL2005/2008)
4. Backup restore using Admin panel

Second, server or VPS

1. New Database
2. Additional databases
3. Backing Up the database
4. Restore the database

Virtual Host

In this case, we only have the database IP address, username and password provided by the space provider (some of the space vendors also provide the online admin panel).

1. Install online Enterprise Manager

This method does not back up and restore the database as a whole, and is typically used to modify databases that have been imported in small scale. Chao Data database products are equipped with this tool, the following is a screenshot of the operation:

"Back to Top"

2. Register Remote Enterprise Manager (SQL2000)

1 This method requires that Microsoft's SQL Server software be installed on our own computers. Open Start Menu-> program->microsoft SQL server-> Enterprise Manager, expand Microsoft SQL Servers->sql Server Group-> (local), and right click sql Server group , and then click New SQL Server registration .

2 in the Register SQL Server Wizard, click Next. Then enter the database IP address under the available server, click Add , and then click Next .

3) Next select The SQL Server login information that the administrator assigned me , and then click Next. Then enter the username password, or click next , and finally click Finish.

4 If the IP address, username and password are correct, and the space trader has opened remote access permission, the connection can be successful. Then click on the new registration database next to the +, will pop-up prompts, click Yes to connect.

5 expand each item sequentially, if see have other database account, don't be surprised, that is the space business opens to other customers, you have no access rights, can only see.

6 Next, right click on the database name, select All Tasks , and then click back up the database or restore the database . For specific actions on backup and restore, see the instructions in the standalone server below.

"Back to Top"

3. Register Remote Enterprise Manager (SQL2005/2008)

1 After you have installed the SQL Server 2005/2008 database on your local computer, open the Start menu-> program->microsoft SQL Servers 2005/2008->sql server Management Studio, The following dialog box will automatically pop up.

2 Enter the IP address on the server name, authentication select SQL Server Authentication, and then enter the database username and password, click Connect . The following steps are similar to SQLServer2000.

"Back to Top"

4, use the admin panel backup restore

The following is an example of a Chao data www.zhaomu.com management panel that demonstrates a backup restore of a SQL Server database (that is, an export import).

1 Click on the database management , find the database to be managed, and then click the admin link.

2) Click on the Backup button, the system will back up the database to the corresponding space. We connect to the space through FTP, in the root directory of the space there is a database backup file, file name is Sq_***.bak.

3 The operation of restoring the database is also very simple. First name the backup file as shown in the image above the file name (such as Sq_***.bak), and then uploaded to the corresponding space in the root directory, and then click the Restore button.

"Back to Top"

Server or VPS

In this case, you have remote permissions for the server or VPS, and you need to create new, append, back up, restore SQL Server databases, and so on.

1. New Database

1 Open the Start menu-> program->microsoft SQL server-> Enterprise Manager, expand the Microsoft SQL Servers->sql Server Group-> (local)-> database in turn, Right-click the database , and then click New Database .

2 The Database Properties dialog box, enter the database name in the General tab, and then specify the name and save location in the data file and log file (it is recommended that you put the database in D), and you can specify the maximum limit for the database.

"Back to Top"

2. Additional Database

Additional databases are especially useful for situations where you have only database source files on hand, namely MDF and LDF files.

1 Open the Start menu-> program->microsoft SQL server-> Enterprise Manager, expand the Microsoft SQL Servers->sql Server Group-> (local)-> database in turn, Right-click the database name, select All Tasks , and then click the attached database .

2 and then enter the MDF file specific path, click to verify , see the following appear two green tick when the description file complete, and then fill in the database name (attached to this), and then click OK , the additional success.

"Back to Top"

3. Backup Database

1 Open the Start menu-> program->microsoft SQL server-> Enterprise Manager, expand the Microsoft SQL Servers->sql Server Group-> (local)-> database in turn, Right-click the database name, select All Tasks , and then click back up the database .

2 On the General tab click Add , and then enter the backup file name, click OK .

"Back to Top"

4, restore the database

1 Open the Start menu-> program->microsoft SQL server-> Enterprise Manager, expand the Microsoft SQL Servers->sql Server Group-> (local)-> database in turn, Right-click the database name, select All Tasks , and then click Restore Database .

2 Click on the General tab from the device , then click on the Select device .

3 then click Add , enter the path of the backup file, click OK , then click OK , return to the General tab.