Database management methods and SQLServer management methods

Database management methods and SQLServer management methods

This article applies to: describes all the operations of SQL Server databases, including virtual hosts and servers.

This article is relatively long. Please visit it using the outline below.

Outline

I. VM

1. Install online Enterprise Manager
2. Register remote Enterprise Manager (SQL2000)
3. Register a remote Enterprise Manager (SQL2005/2008)
4. Use the Management Panel to back up and restore

Ii. servers or VPS

1. Create a database
2. Attach a database
3. Back up the database
4. Restore the database

Virtual Host

In this case, we only provide the database IP address, user name, and password provided by the Space Provider (some also provide the online management panel ).

1. Install online Enterprise Manager

This method cannot be used to back up and restore the database as a whole. It is generally used to modify the imported database on a small scale. This tool is available in all database products of the morning and evening data. The following operations are performed:

 

[Back to Top]

2. Register remote Enterprise Manager (SQL2000)

1) This method requires that Microsoft's SQLServer software is installed on our own computer. Choose Start> program> Microsoft SQL Server> Enterprise Manager, expand Microsoft SQL Servers> SQL Server group> (local), right-click the SQL Server group, click create SQL Server registration.

2) in the register SQL Server wizard, click Next. Enter the database IP address under the available server, click Add, and then click Next.

3) Next, select the SQL Server login information assigned to me by the Administrator, and then click Next. Enter the user name and password, click Next, and click Finish.

4) if the IP address, user name, and password are correct, and the Space Provider has enabled the remote access permission, the connection will be successful. Click + next to the newly registered database. A prompt is displayed. Click Yes to connect.

5) Expand the items in sequence. If you see other database accounts, you don't have to be surprised. It's what the Space Provider opened to other customers. You don't have access permissions, but you can only see them.

6) Next, right-click the database name, select all tasks, and then click back up database or restore database. For details about how to back up and restore data, see the description in the independent server section below.

 

[Back to Top]

3. Register a remote Enterprise Manager (SQL2005/2008)

1) After the SQLServer 2005/2008 database is installed on the Local Computer, choose Start> program> Microsoft SQL Server 2005/2008> SQL Server Management Studio. The following dialog box is displayed automatically.

2) enter the IP address on the Server name, select SQL Server for authentication, enter the database user name and password, and click Connect. The subsequent steps are similar to those of SQLServer2000.

 

[Back to Top]

4. Use the Management Panel to back up and restore

The following uses the Management Panel of www.zhaomu.com as an example to describe how to back up and restore an SQLServer database (that is, export and import ).

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

2) Click the backup button to back up the database to the corresponding space. We connect to the space through FTP, and there is a database backup file under the root directory of the space. The file name is sq _ ***. bak.

3) it is easy to restore the database. First, name the backup file into the file name displayed in (such as sq _ ***. bak), upload it to the root directory of the corresponding space, and then click the restore button.

 

[Back to Top]

Server or VPS

In this case, you have the remote permissions of the server or VPS and need to create, attach, back up, and restore the SQLServer database.

1. Create a database

1) choose Start> program> Microsoft SQL Server> Enterprise Manager, and expand Microsoft SQL Servers> SQL Server group> (local)> database, right-click the database and then click Create Database.

2) In the database Properties dialog box, enter the database name in the General tab, and specify the name and storage location in the data file and log file (we recommend that you store the database on disk D ), you can also specify the maximum database quota.

 

[Back to Top]

2. Additional database

Attaching a database is especially suitable for scenarios where you only have database source files on hand, that is, mdf and ldf files.

1) choose Start> program> Microsoft SQL Server> Enterprise Manager, and expand Microsoft SQL Servers> SQL Server group> (local)> database, right-click the database name, select all tasks, and then click attach database.

2) then enter the specific path of the mdf file and click Verify. The following two green hooks are displayed, indicating that the file is complete. Then fill in the Database Name (attached as this option) and click OK, the append is successful.

 

[Back to Top]

3. Back up the database

1) choose Start> program> Microsoft SQL Server> Enterprise Manager, and expand Microsoft SQL Servers> SQL Server group> (local)> database, right-click the database name, select all tasks, and then click back up database.

2) Click Add on the General tab, enter the backup file name, and click OK.

 

[Back to Top]

4. Restore the database

1) choose Start> program> Microsoft SQL Server> Enterprise Manager, and expand Microsoft SQL Servers> SQL Server group> (local)> database, right-click the database name, select all tasks, and then click Restore database.

2) on the General tab, click "device from", and then click "device.

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